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
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.
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.
amjad905
Member
569 Points
519 Posts
SQL Server 2012
May 01, 2012 09:47 PM|LINK
Hi,
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
please help....
dotnetdev201...
Member
319 Points
79 Posts
Re: SQL Server 2012
May 01, 2012 09:59 PM|LINK
Try this...
http://blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx
amjad905
Member
569 Points
519 Posts
Re: SQL Server 2012
May 01, 2012 10:12 PM|LINK
Hi,
The link does not make any sense to me :( please could you explain in your own words.
brady575
Member
12 Points
3 Posts
Re: SQL Server 2012
May 01, 2012 10:53 PM|LINK
Hello,
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!
Thanks
Eric
Chakka123
Member
2 Points
1 Post
Re: SQL Server 2012
Mar 08, 2013 05:15 AM|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.