The report server can’t connect to its database because it doesn’t have permission

Question

Suddenly, I got this error "The report server can’t connect to its database because it doesn’t have permission" when opening the Power BI report server portal

The service is not available.
The report server isn’t configured properly. Contact your system administrator to resolve the issue. 
System administrators: The report server can’t connect to its database because it doesn’t have permission to do so. 
Use Reporting Services Configuration Manager to update the report server database credentials.

No one change the permission or the password od the report server account that used to connec to the database

Answer 1

This issue "The report server can’t connect to its database because it doesn’t have permission" might occur if the account that the report server uses to connect to the report server database is

• Disabled or Locked.
• Its password has changed recently.
• It doesn't have owner permission on the Report Server databases (its permission has revoked).

This Report Server account can be one of the below types:

1. Windows domain user account.
2. SQL Server account.
3. The same service account that used to run the Power BI Report Server service.

And, you can find the current report server account login type at

• Report Server Configuration Manager > Database > current report server credentials as below:

  

---

So, to solve this error "The report server can’t connect to its database because it doesn’t have permission", you have to do the following:

1) Check the Report Server Account Status

Many organizations disable SQL authentication for security concerns, So, if the report server account is a Windows domain user account, you should make sure that it's not disabled or locked in Active Directory as below:

• Ask your system administrator to check the account status in the Active Directory and make sure that it's enabled and unlocked

  

2) Report Server Database Permission Required

Also, you should ensure that this account has owner permission on the two report server databases as below.

• Open SQL Server Management Studio > connect to the report server instance.
• Go to Security > Right-click on the user.
• Click on User Mapping, and make sure that it has owner permission for the report server and temp databases as below.
  

3) Check the user status in SQL Server

Again, click on Status, make sure that the login is not disabled and not locked as below.

4) Update the report server database credentials

Now, you should reconfigure the report server database credentials by doing the following:

• Open Report Server Configuration Manager > Connect to your instance.
• Go to Databases, below current report server credentials> click on "Change Credentials".
• Follow the wizard, and provide the correct account Credentials and make sure that the wizard is completed successfully.
• Finally, restart the Power BI Report server service in Services.
  

---

See Also

• Install and Configure Power BI Report Server Step by Step.
• Watch and star My Power BI repo on GitHub to get the latest update.

Comments

Great explanation, my account was disabled and after enabling it the error is gone! Thank you!