Create Database Permission Denied

Problem:


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'"


Reason:


This error message appears when the user that is trying to create the database doesn't have the necessary permissions in SQL server.


Solution:


  • 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 , sa.

If the above didn't help, you can assign these roles to NT AUTHORITY\NETWORK SERVICE and DOMAIN\MACHINE_WITH_APPSERVER_NAME$



CASO Knowledge Base