Articles in this section
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.

http://www.syncfusion.com/uploads/user/kb/ump/ump-3172/ump-3172_img2.png

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

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied