Share via

Reporting Services failing over

Mohammad Sultan: H&F 0 Reputation points
2026-01-13T12:14:34.3033333+00:00

We are encountering the following error when browsing to the SSRS web 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."

Background:

  • SSRS has been working fine for years.
  • Recently, we restricted server traffic for security reasons.
  • After reopening traffic, this issue started occurring.

Steps Taken:

  • Verified SSRS service is running.
  • Checked firewall rules and network connectivity.
  • No changes were made to SSRS configuration or database credentials prior to the issue.

Request: Please advise on resolving this error and restoring SSRS functionality.We are encountering the following error when browsing to the SSRS web 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."

Background:

  • SSRS has been working fine for years.
  • Recently, we restricted server traffic for security reasons.
  • After reopening traffic, this issue started occurring.

Steps Taken:

  • Verified SSRS service is running.
  • Checked firewall rules and network connectivity.
  • No changes were made to SSRS configuration or database credentials prior to the issue.

has anyone faced this issue and can help please?

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments
Answer recommended by moderator
  1. Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
    2026-01-19T07:17:15.9633333+00:00

    Hi @Mohammad Sultan: H&F ,

    Yes, this issue commonly occurs after firewall or security changes. Try with bellow steps.

    1. Log in to the SSRS server.
    2. Open Reporting Services Configuration Manager.
    3. Connect to the SSRS instance.
    4. Go to Database → click Change Credentials.
    5. Re-enter the existing service account / SQL login (no need to change it).
    6. Apply and restart the SSRS service.

    After re-saving the database credentials, SSRS reconnects to the ReportServer database and the web portal loads normally.

    This happens because SSRS loses its secure database connection after network restrictions, even if nothing was changed manually.

    Thanks,
    Akhil.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2026-01-13T12:14:47.2366667+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    The error message you are encountering indicates that the SSRS (SQL Server Reporting Services) cannot connect to its database, likely due to permission issues. Since you mentioned that the issue started after reopening server traffic, it's possible that the firewall or network settings may still be affecting the database connection.

    Here are some steps you can take to resolve the issue:

    1. Check Database Permissions: Ensure that the service account used by SSRS has the necessary permissions to access the report server database. You may need to use the Reporting Services Configuration Manager to verify and update the database credentials.
    2. Verify Connection Strings: Check the connection strings in the SSRS configuration to ensure they are correct and point to the right database. This can be done through the Reporting Services Configuration Manager.
    3. Firewall Settings: Double-check the firewall settings to ensure that the SSRS service can communicate with the SQL Server database. Ensure that the appropriate ports are open and that there are no restrictions on the SQL Server instance.
    4. Service Account Configuration: Make sure that the service account running the SSRS has not lost permissions on the SQL Server database. You may need to reconfigure the service account using the Reporting Services Configuration tool.
    5. SQL Server Database Engine: Ensure that the SQL Server Database Engine service is running and that it is configured to allow remote connections.

    If after these checks the issue persists, you might want to review the SSRS logs for any additional error messages that could provide more insight into the problem.

    References:

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.