Manual Steps to Configure the Remote SQL Server Reporting Services

  • Article

Applies To: System Center Service Manager 2010 SP1

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.

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 folder \Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\Bin on the computer that is hosting SSRS. 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. In the following procedure, the default instance name is used.

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

  1. On the computer that is hosting SSRS, open an instance of Windows Explorer.

  2. Perform one of the following steps based on which version of SQL Server 2008 you are using:

    1. For SQL Server 2008 SP1, locate the folder \Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\Bin.

    2. For SQL Server 2008 R2, locate the folder \Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\Bin.

  3. Start 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 either step 2a or step 2b.

To add a code segment to the Rssrvpolicy.config file

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

  2. Using an XML editor of your choice, open the Rssrvpolicy.config file.

  3. Scroll through the Rssrvpolicy.config file and locate the CodeGroup code segments. The following code shows an example of a CodeGroup segment.

    <CodeGroup
   class="UnionCodeGroup"
   version="1"
   PermissionSetName="FullTrust">
   <IMembershipCondition 
      class="UrlMembershipCondition"
      version="1"
      Url="$CodeGen$/*"
   />
</CodeGroup>

  4. Add the following CodeGroup segment to the same section as the other CodeGroup segments in the Rssrvpolicy.config file.

    <CodeGroup 
   class="UnionCodeGroup" 
   version="1" 
   PermissionSetName="FullTrust" 
   Name="Microsoft System Center Service Manager Reporting Code Assembly" 
   Description="Grants the SCSM Reporting Code assembly full trust permission."> 
   <IMembershipCondition 
      class="StrongNameMembershipCondition"   
      version="1"
      PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100B5FC90E7027F67871E773A8FDE8938C81DD402BA65B9201D60593E96C492651E889CC13F1415EBB53FAC1131AE0BD333C5EE6021672D9718EA31A8AEBD0DA0072F25D87DBA6FC90FFD598ED4DA35E44C398C454307E8E33B8426143DAEC9F596836F97C8F74750E5975C64E2189F45DEF46B2A2B1247ADC3652BF5C308055DA9" 
/>
</CodeGroup>

  5. Close the XML editor and save the changes.

Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to scsmdocs@microsoft.com.