Symptoms
The following error message appears when an attempt is made to create a database using the Administration and Monitoring Console:
"Cannot configure database
Description CREATE DATABASE permission denied in database 'master'"
Cause
This error message appears when the user that is trying to create the database doesn't have the necessary permissions in SQL Server.
Resolution
To create the database:
- Open the Security folder, then open the Logins folder and select the user account under which you want to create the database.
- Open the account's Properties, select the Server Roles tab and then select the dbcreator checkbox (sysadmin works even better).
You can also try to create the database while logged in under the standard administrator account.
If the above didn't help, you can also assign these roles to NT AUTHORITY\NETWORK SERVICE and DOMAIN\MACHINE_WITH_APPSERVER_NAME$.
Comments
0 comments
Please sign in to leave a comment.