Thursday, February 16, 2012

Cant't see the database

When I create a database with the administrator acount on the server in SQL 2005, it adds and I can see it (and the system databases too).

Then I added a user accout (Windows Auth), and connect to the database from the new accout, but I can't see the database I just created myself with the administrator accout (on the server) just the 'System Databases'.

I even tried to make a database with the new user account but get permission denied, even if I set dbcreator permission on the user. I get the error

"CREATE DATABASE permission denied in database 'master'".

Any ides?

Oh, i solved it by Connect, then choose the Options>> button,

And then in "Connect to database:" I choose my database.

No comments:

Post a Comment