November 22, 2006 at 1:48 pm
I created a SQL ID in 2005 and made it dbo on a database. When I try to connect to the database using SSMS and the user I just created, i can't see the database in there, even though I can execute ddl commands against that database.
I have SP1 also installed on it.
TIA
November 22, 2006 at 11:17 pm
Did you try refreshing the Object Explorer? Right click on the server name and click refresh.
November 27, 2006 at 9:12 am
Yes, I re-connected to the server in SSMS but still can't see that database.
Any other suggestions.
November 27, 2006 at 10:15 am
I didn't ask if you re-connected. I asked if you refreshed.
November 27, 2006 at 11:39 am
I refreshed as well
November 27, 2006 at 11:43 am
Are you using the same account for the object explorer and for the query window?
November 27, 2006 at 12:40 pm
Yes, I'm connected as the same user. Moreover, when I click New Query it opens a new window and then shows me the database name in the drop down list.
But in the Object Explorer, I only see System Database (master, tempdb) and Database Snapshot.
The moment I make this user sysadmin, i can see all the databases. I have tried this on 2 different workstations if it helps.
November 27, 2006 at 12:49 pm
I'm out of ideas.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply