Last post Mar 08, 2013 01:15 AM by Chakka123
May 01, 2012 05:47 PM|amjad905|LINK
I have installed SQL Server 2012. I have tried to add a new database and it says "Create failed for Database Test" Create Database permission denied in database 'master'.
When I expand a database it says The database is not accessible
May 01, 2012 05:59 PM|dotnetdev2010|LINK
May 01, 2012 06:12 PM|amjad905|LINK
The link does not make any sense to me :( please could you explain in your own words.
May 01, 2012 06:53 PM|brady575|LINK
Typically this message means that you don't have the correct permissions to create a database(in particular to the master database). If you have access to the SA user and password I would suggest logging in as that user to create the database. If not then
you'll want to open Management Studio and go to Security | Your User | Properties | Server Roles. From there you'll need at minimum DBCreator. You'll also want to check the User Mappings that determine your access level to Master here.
Hope this helps!
Mar 08, 2013 01:15 AM|Chakka123|LINK
Thanks for your reply, It helps me
Actually I created database as "Administrator" user and tried to access as non administrator user. The problem solves after i run the Sql Management studio as Administrator user. Now I am able to access the database.