Trusted connection with user with admin rights

[Luvsql]

My user is setup in SQL as a NT authenticated user. Whenever I try to use this login in Crystal 9, with trusted connection, the only things I see are dbo stored procedures. I don't see any tables or views, even though I can query them in sql. Why is it not listing them? This has been a problem all along and have not figured out how to fix this.

 

[synapsevampire]

Check the File-?Options->Database->Data Explorer to make sure that Tables and Views are selected.

-k

 

[Luvsql]

Yes they are selected. I don't have the issue if a use a sql login ID and password ie non-trusted.

 

[MJRBIM]

Are you using the SAME SQL loginID and password when you try to connect with (and without) the trusted-connection...?

 

[Luvsql]

No. I have the issue with a Windows NT authenticated user (my own) and use a different sql login ID and password (non-NT) and it works.

 

[MJRBIM]

Do both logins (NT and non-NT)have the same rights on the SQL database..?

Sounds like one of the logins has much more limited rights on the SQL side.

 

[Luvsql]

Yes both the NT user and the non-NT user have select on the one view I am using.

It's not a permission issue. My NT user is an administrator on our domain,so SQL server automatically gives me dbo permissions. My issue is when I use this loging with CR 9 and I connect to a database via ODBC using a trusted connection, it ONLY lists some dbo owned stored procedures and NONE of the tables/views that that user has been assigned select permissions on.