Last week I had some challenges getting Service Manager Reporting working properly in a scenario with a remote SQL Server Reporting Services (SSRS) as shown below.
During deployment of the Service Manager data warehouse management server, you can specify the server to which Microsoft SQL Server Reporting Services (SSRS) will be deployed. By default, the computer that is hosting the data warehouse management server is selected during setup. If you specify a different computer, you are prompted to follow this procedure to configure the remote SSRS server. Before you follow this procedure, you must perform the following actions:
- Copy Microsoft.EnterpriseManagement.Reporting.Code.dll from the Service Manager installation media to the computer that is hosting SSRS.
- Add a code segment to a configuration file on the computer that is hosting SSRS.