Account cannot connect to SQL server reporting services

Last Modified

Wed Jun 12 11:00 GMT 2025

Description

  • When running the installer for N-able Report Manager you may get the following error message:

Error: Account cannot connect to SQL server reporting services

Environment

  • N-able N-central
  • N-able Report Manager

Solution

  • This is because the installer tries to access the reporting services over 127.0.0.1 and localhost .
  • Either the site is not setup correctly in reporting services or the account has not been added in reporting services.
  • This can also be caused if the reporting services are not running.
  1. Ensure the SQL Server Reporting Services service is running and set to run logon as local system
  2. Ensure that reporting services are configured to use all assigned IP addresses:
    1. Open SQL Server Reporting Services Configuration Manager.
    2. Go to Web Portal URL.
    3. Click Advanced.
    4. Ensure the TCP port is 80 and IP Address is "All Assigned" under "Multiple HTTP Identities for the currently selected Reporting Services Feature".
    5. Go to Web Service URL.
    6. Click Advanced.
    7. Ensure the TCP port is 80 and IP Address is "All Assigned" under "Multiple HTTP Identities for the currently selected Reporting Services Feature" .
  3. Make sure that the appropriate roles are assigned in reporting services:
    1. Open http://localhost/reports In any browser window
    2. Go to folder settings .
    3. Click New Role Assignment.
    4. Add the user that are using in the installer and select content manager, and then click Ok.
    5. Click site settings in the top right corner.
    6. Click security on the left hand side.
    7. Click New Role Assignment.
    8. Add the user that you are using in the installer and select system user and then click OK.