Account cannot connect to SQL server reporting services

Last Modified

07.01.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. Make sure that TCP port is 80 and IP Address is "All Assigned (Recommended)".
   4. Go to N-able Report Manager URL.
   5. Make sure that TCP port is 80 and IP Address is "All Assigned".
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.