Hi anthony strother,
Just checking in, were you able to get the issue resolved? If so, it would be great if you could mark the answer as Accepted so others in the community can benefit from your experience. Thank you!
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Attempting to install Reporting Services for SCOM 2019, on same server as SSRS 2019, v15.0.9395.19445. I get the error msg, "Unable to connect to Data Access Service for this server".
I have tried removing SSRS and re-installing with no success.
Thanks, Tony
Hi anthony strother,
Just checking in, were you able to get the issue resolved? If so, it would be great if you could mark the answer as Accepted so others in the community can benefit from your experience. Thank you!
Hi anthony strother,
The error message “Unable to connect to Data Access Service for this server” typically occurs when the SCOM Reporting Services role is installed on a server that already hosts a standalone SSRS instance. SCOM requires a dedicated SSRS instance configured specifically for Operations Manager, and it cannot share the same SSRS instance used for other reporting workloads. Even reinstalling SSRS will not resolve the issue unless the instance is provisioned in SCOM mode.
To move forward, ensure that you install SSRS in native mode and then configure it using the SCOM setup wizard, which will register the Data Access Service correctly. It’s also important to verify that the account running the installation has both local administrator rights and SQL sysadmin rights, as insufficient permissions can block the connection. If you need to keep SSRS for other applications, the recommended approach is to host SCOM Reporting Services on a separate SSRS instance or server to avoid conflicts.
I hope this guidance helps clarify the root cause and the next steps. If this explanation is useful, please hit “Accept Answer” so I know your concern is resolved 🙂.
Jason.
AI answer
The error message "Unable to connect to Data Access Service for this server" when attempting to install Reporting Services for SCOM 2019 on the same server as SSRS 2019 may be related to misconfiguration of the Data Warehouse Report Deployment Account and Data Warehouse Account Run As profiles. Ensure that these profiles are correctly set up and that the default action account has the necessary SQL Server permissions.
If the issue persists, consider verifying the permissions of the System Center Operations Manager databases (OperationsManager and OperationsManagerDW) to ensure they are set correctly. Additionally, check the setup logs for any specific errors that might provide more insight into the problem.
If you have already tried removing and reinstalling SSRS without success, you might want to explore reconfiguring the profiles using PowerShell or manually checking the configurations as outlined in the documentation.
References: