Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

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.