Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
10.6k views
in Power BI by 7 8 13

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 report server can’t connect to its database because it doesn’t have permission

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


1 Answer

1 like 0 dislike
by 97 167 336
selected by
 
Best answer

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:

    current report server database credential


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

    unlock and enable report server account

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.
    report server database permission required

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.

permission to connect to database engine

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.
    restart the Power BI Report server service

See Also

by 7 8 13
0 0
Great explanation, my account was disabled and after enabling it the error is gone! Thank you!
If you don’t ask, the answer is always NO!
...