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



Answer this question

Cant't see the database

  • LT Chia

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

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


  • Cant't see the database