Click here to Skip to main content
15,891,136 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
can any one help me. I'm new to .net. i'm getting this - create database permission denied in database 'master' sql server 2005
Posted
Updated 14-Mar-14 4:02am
v3
Comments
CHill60 14-Mar-14 9:54am    
It's nothing to do with .NET - you don't have permission to create things in the 'master' database. Try connecting to another database within that sql server instance

The error message is pretty self explanatory: "create database permission denied in database 'master'"
The user you have connected to SQL with does not have permission to create a database. You need to either create or use a different user account, with the appropriate permissions. If you don't know any other user accounts, then talk to your DBAdmin and he will sort you out.
 
Share this answer
 
Go to Microsoft Sql Server Management Studio(SSMS) , if you don't have this tool installed you can get it at the website of Microsoft when you do a search for it in the [downloads section]and install the appropriate version.
When you open the Sql Server Management Studio with your administrator account you get the name of your server on the left side and a list of folders.
Go to the security folder and inside that the Login folder. When you right click on the Login Folder you have the option to create a new Login, within the folder you have the existing Logins. Per Login you can go with right click to the properties option in the menu and you get all the options for that specific login and that's where you can grand the dbcreator (server wide security) privileges to that Login. Be aware that the right database must be selected in the user mappings also and all other settings must be ok but for that you have to look at the different pages in the left pane were all pages are listed.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900