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

Avatar

Margarita Nefedova

  • Edited

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

  1. Open the Security folder, then open the Logins folder and select the user account under which you want to create the database.
  2. 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.

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.