0

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?

Improve this question

1 Answer 1

Reset to default
0

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.

Improve this answer
1
  • 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. Commented Aug 26, 2009 at 14:08

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.