Cannot access tables/views using dbo on sql server with CR 9

[Luvsql]

I am trying to access my tables/views using adminstrator account with NT authentication, but it is only listing stored procedures (and not all of them). If I unmark the stored procedures, it doesn't list any tables or views, even though administrator is the dbo and it has access to all the tables/views on the sql server.

I know with version 9 you cannot use the table name like (no workaround or fix), so how can I create a report using dbo account if I can't see any of the tables/views within Crystal Reports?

 

[synapsevampire]

Did you turn on the File-Options-Database-Tables and the Views?

You may have a permission issue as well. Use the SQL Server login and the SA account, you should be able to see everything.

-k