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