SCOM Reporting Server Migration - AccessDeniedException

Malako 136 Reputation points
2021-02-10T15:31:11.27+00:00

Hi!

We've upgraded our SCOM environment to 2019 UR2 and are now migrating the SQL-databases from SQL2016 on W2016 to a new server with SQL2019 on W2019

We kept all the hostnames intact and followed the upgrade procedure except for the parts where we change the hostnames - everything is up and running now apart from the Reporting Server.

For the Reporting Server we followed the guide to upgrade except we installed the Reporting Services on the new server and restored the old databases to this server instead.

Now we're stuck at verifying part 3 of Verify the installation of SQL Report server - Verifying the Web Portal

The page loads with the error The service is not available (The /ReportServer-page loads and lists reports in )
--- I find no indication of what the error could be in the Reporting Service logfiles.

The reports are visible in the SCOM Console - however running a report generates the rsAccessDenied exception saying that my user has insufficient permissions.
--- My account is both local admin aswell as sysadmin on the SQL Instance.

The configuration is set up to use the same account (OURDOMAIN\om-reporting) for Service Account and Execution Account.
--- The account is, at the moment, (for troubleshooting purposes) a local admin account on the server and has "Log on as a service rights"

It has the role public on the SQL-Instance and the user mapping of db_owner, public and RSExecRole on the ReportServer DB and other mappings according to Microsoft guides.

Could it be a simple issue of NTFS-security on folders? Also - is it a bad practice to use the same account for Execution/Service and using a domain account?

Thank you!

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,413 questions
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.
2,797 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. XinGuo-MSFT 14,236 Reputation points
    2021-02-11T09:05:37.607+00:00

    Hi,

    Have you tried to backup and restore the encryption key from old report server instance?

    Installation of SQL Server Reporting Services to a New Server