Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|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. – cesdev Aug 26 '09 at 14:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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