"CREATE DATABASE permission denied" error when trying to create a database

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$.

Was this article helpful?

6 out of 49 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.