Category / Section
How to fix "CREATE DATABASE permission denied in database master" in Report Server?
2 mins read
If you receive the following error message CREATE DATABASE permission denied in database ‘master’, check whether the user account has ‘dbcreator’ access. If the user account does not have access to the SQL Server, follow the given steps to add the role:
Step 1: Expand the Security tab.
Step 2: Right-click the Logins folder and select the user account under which you want to create a database.
Step 3: Right-click the user account and select the Properties tab.
Step 4: In the Server Roles tab, select the dbcreator check box.
Step 5: Click OK and try to create a database in the user account.
If you still face the problem, you can also assign these roles to NT AUTHORITY\NETWORK SERVICE and DOMAIN\MACHINE_WITH_APPSERVER_NAME$.