How to configure SQL Server 2012 Data Tools to support OpsMgr reports development

This is just a short note on how to configure SQL Server 2012 Data Tools to support OpsMgr reports development.

Note: Since I do not use Dundas Chart any more, I haven’t tried to install it. SSRS native chart control is the prefered option in my opinion. However, if you still need it, you may try steps described here.

  1. Copy Microsoft.EnterpriseManagement.Reporting.Code.dll from SSRS bin folder to C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\
  2. Add ManagementGroupId key to C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\PreviewProcessingService.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 10.0\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config as follows: open file in text editor and find first <CodeGroup> element. Add this code after the first 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: Instructions for BIDS 2008 are here. 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.

PPS: If you experience any issues with your old shared data source – try to recreate it.

Leave a Comment