up vote 0 down vote favorite
share [g+] share [fb]

Just an odd problem with my SQL server this morning... Locally I am able to connect to the SQL Server Studio but unable to view tables, etc when I am on theserver. I am able to connect however from other workstations using the same login, and able to view tables etc. I don't believe any settings or major upgrades were made.

Any ideas?

link|improve this question
83% accept rate
feedback

1 Answer

up vote 0 down vote

Which account are you connecting as locally vs. remotely? SQL 2005's Manglement studio remembers the last login used, so if you've got a no-privilege user's credentials left in there, you may not get to see as much as you do when connecting as Admin/sa/whatever. I got freaked out by this when I accidentally connected as a reporting user and started stressing about where all the tables had gone.

link|improve this answer
Locally on the server administrator was being used to login to windows server 2003, then inside the SQL Management Studio sa was being used. Remotely, both sa and other users can login. It really only happens using the administrator on the 2003 server. – walter scott Aug 26 '09 at 14:08
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.