Use System Center Operations Manager? Respond to the annual survey:
How do you use SCOM Reporting?

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.

Connect with me:

Leave a Comment

  • About me

    Oleg Kapustin

    People say that I'm an IT Pro and good at SQL and OpsMgr. Who knows, this may be true :)

    I worked for Ozon.ru, DataArt, one well-known tobacco company, Veeam and VIAcode.

    Should you want to contact me, please use this page.

    All opinions posted on this site are solely my own. They may be not endorsed by any third party.
    All information is provided AS IS.
    No warranties.