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
- 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 select the dbcreator or sysadmin checkboxes.
If the above didn't help, try assigning these roles to NT AUTHORITY\NETWORK SERVICE and DOMAIN\MACHINE_WITH_APPSERVER_NAME$ logins.
Comments
0 comments
Please sign in to leave a comment.