I have two SQL servers, one 2000 server, and a 2005 server.
As far as I can tell the permissions are configured the same, when I add an ODBC connection to the 2000 server, in the "Administrative Tools, Data Sources (ODBC)" where is says "Change default database to" I can click the down arrow and see a list of all tables on this server. But when I create a connection to the 2005 server I cannot see all tables, only master and tempdb.
Why can I not see all tables on the 2005 server?
I would hazard a guess that the issue is security. It sounds like the login being used to access the Server doesn't have access to any of the databases. You should try connecting with a different account, one that you know has the access, or have someone else do that for you, and check the security setting for the login attempting to connect.
answered Sep 20 '10 at 11:56 AM
Grant Fritchey ♦♦