Unable to view tables and views only sps

[mebenz]

CR designer 9. Using ODBC NT authenticated. My NT login setup in sql server is not a dbo, yet when I create a report, choosing ODBC, then a database, right underneath the database ID is dbo and I only see system stored procedures.

I have verified that my network user ID does have select, insert, delete and updates on all tables and views in the database.

I know I have seen this exact same issue when using the 'sa' login ID as well, but cannot remember the fix. If I use a sql login (non trusted) which has identical permissions as mine, it works.

 

[synapsevampire]

Within Crystal make sure that File->Options->Database has Tables and Views selected

Otherwise it's probably your database permissions that need to be altered, which isn't done within Crystal.

 

[mebenz]

Those are both marked. When I use an non-trusted login (ie a sql login) I can see all tables and views, so it is not a CR setting.

It is not database permissions either as I can log into Query Analzer with my network login and select all tables, delete , insert.

 

[mebenz]

If I use MS Access with the same ODBC, I am able to open all the tables and views. When I use Crystal, I only see dbo then some stored procedures. It is not a permissions issue, nor an ODBC issue.

 

[mebenz]

I removed my nt login completely from all databases so I have no access at all. I create a new report, choose my ODBC, mark trusted connection, choose a company and it still lists all the stored procedures. It is obviously not using my windows login, but seems to be using something else? This makes zero sense.

Access and Query Analyzer works fine, so what's wrong with Crystal?