Configure SQL Server Business Intelligence Development Studio 2008 to support OpsMgr reports development

Update: Instructions for SQL Server 2012 Data Tools are here.

This is just a short note on how to configure BIDS 2008 to support OpsMgr reports development.

  1. Copy Microsoft.EnterpriseManagement.Reporting.Code.dll from SSRS bin folder to C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
  2. Add ManagementGroupId key to devenv.exe.config: just copy <appSettings>…</appSettings> section from your ReportingServicesService.exe.config like this:
    <configuration>
      ...
      <appSettings>
        <add key="ManagementGroupId"
          value="Your management group's GUID goes here" />
      </appSettings>
    </configuration>
  3. Modify C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config as follows: open file in text editor and find first <CodeGroup> element. Add this code after child element:
      <CodeGroup 
       class="UnionCodeGroup" 
       version="1" 
       PermissionSetName="FullTrust" 
       Name="Microsoft Operations Manager Reporting Code Assembly" 
       Description="Grants the MOM Reporting Code assembly full trust permission.">
        <IMembershipCondition class="AllMembershipCondition" version="1" />	
      </CodeGroup>

    This is how it should look after modification:

    ...
    <CodeGroup 
     class="FirstMatchCodeGroup"
     version="1"
     PermissionSetName="Nothing">
      <IMembershipCondition 
       class="AllMembershipCondition"
       version="1" />
      <CodeGroup 
       class="UnionCodeGroup" 
       version="1" 
       PermissionSetName="FullTrust" 
       Name="Microsoft Operations Manager Reporting Code Assembly" 
       Description="Grants the MOM Reporting Code assembly full trust permission.">
        <IMembershipCondition class="AllMembershipCondition" version="1" />	
      </CodeGroup>
    ...

That’s it! Happy coding!

PS: If you still want to use BIDS 2005, please refer this post and keep in mind that SQL Server 2005 is out of mainstream support.

Leave a Comment