Remote SQL Server Reporting Services

  • Article

Applies To: System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager

When you installed System Center 2012 – Service Manager Service Pack 1 (SP1), you may have specified a different computer to host Microsoft SQL Server Reporting Services than the computer that hosted the data warehouse management server. If, in your environment, Reporting Services is remote from the data warehouse management server, you must use the following procedures to prepare the computer that hosts Reporting Services for the upgrade:

  • Copy Microsoft.EnterpriseManagement.Reporting.Code.dll from the Service Manager installation media to the computer that is hosting Reporting Services.

  • Add an Extension tag to the existing Data segment in the rsreportserver configuration file on the same computer.

If you used the default instance of SQL Server, use Windows Explorer to drag Microsoft.EnterpriseManagement.Reporting.Code.dll (which is located in the Prerequisites folder on your Service Manager installation media) to the \Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\Bin folder on the computer that is hosting Reporting Services. If you did not use the default instance, the path of the required folder is \Program Files\Microsoft SQL Server\MSRS10.INSTANCE_NAME\Reporting Services\ReportServer\Bin. The following procedure uses the default instance name.

To copy the Microsoft.EnterpriseManagement.Reporting.Code.dll file

  1. On the computer that will host the remote instance of Reporting Services, open an instance of Windows Explorer.

  2. Locate the \Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\Bin folder.

  3. Open a second instance of Windows Explorer, locate the drive that contains the Service Manager installation media, and then open the Prerequisites folder.

  4. In the Prerequisites folder, click Microsoft.EnterpriseManagement.Reporting.Code.dll and drag it to the folder that you located in step 2.

To add an Extension tag to the Data segment in the rsreportserver.config file

  1. On the computer that is hosting Reporting Services, locate the rsreportserver.config file in the \Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer folder.

  2. In an XML editor of your choice (such as Notepad), open the rsreportserver.config file.

  3. Scroll through the rsreportserver.config file and locate the <Data> code segment. This file contains only one <Data> code segment.

  4. Add the following Extension tag to the <Data> code segment where all the other Extension tags are.

    <Extension Name="SCDWMultiMartDataProcessor" Type="Microsoft.EnterpriseManagement.Reporting.MultiMartConnection, Microsoft.EnterpriseManagement.Reporting.Code" />

  5. Save the changes, and then close the XML editor.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----