/
Create DATABASE permission denied in database 'master'

Create DATABASE permission denied in database 'master'

Owned by Ruud de Bruijckere
Last updated: 11 Dec 2020 by Kenneth Jonsson

Problem

If the user running the application pool does not have the rights to create a database on the SQL instance, it will not be able to create the server database the first time you access the web application. You will get the following error message:

Solution

To solve this the application pool user need sufficient privileges in the database:

  • open the SQL Server Management Studio and connect to the database instance used when mounting databases
  • expand Security / Logins
  • right-click on the IIS application pool identity setup for the application - it is often the NT AUTHORITY\SYSTEM user
  • select Properties and Server Roles
  • include the server role: sysadmin to enable the application to handle databases

Related content

Web application fail to start with a manual database definition
Web application fail to start with a manual database definition
Signifikant Knowledge Base
More like this
Technical instruction - Configure Application Pool Identity
Technical instruction - Configure Application Pool Identity
Signifikant Knowledge Base
More like this
The server was not found or was not accessible
The server was not found or was not accessible
Signifikant Knowledge Base
More like this
Grant login to SqlServer after users have changed domain
Grant login to SqlServer after users have changed domain
Signifikant Knowledge Base
More like this
.NET Core app deployment
.NET Core app deployment
Signifikant Knowledge Base
More like this
Deploy application failure doe to denied access
Deploy application failure doe to denied access
Signifikant Knowledge Base
More like this