Configuring SmartCodeDeveloper for Business Intelligence Development Studio and SQL Server 2008 R2 Reporting Services

The configurations described in this section are to be used with 32-bit version of Windows. This include Windows XP / Windows Vista / Windows 7 (32-bit).

Business Intelligence Development Studio for MS SQL Server 2008 R2

SmartCodeDeveloper.dll will need to be copied to the [Business Intelligence Studio InstallDir]\Common7\IDE\PrivateAssemblies\ directory of Business Intelligence Development Studio. The default directory is C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\.

RSPreviewPolicy.config
This is the Report Designer stand-alone preview policy configuration file. The default path for this file is [Business Intelligence Studio InstallDir]\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config. The following tag will need to be added to the RSPreviewPolicy.config file. It grants SmartCodeDeveloper FullTrust permission to run in Report Designer Preview.

<CodeGroup class="UnionCodeGroup" Name="SmartCodeDeveloperControl" version="1" PermissionSetName="FullTrust" Description="This code group grants SmartCodeDeveloper.dll FullTrust permission.">
<IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\SmartCodeDeveloper.dll"/>
</CodeGroup>


Note : You might see several existing <CodeGroup> tags. The recommended place to put the above tag will be as follow:

<CodeGroup>
  <CodeGroup>
   <CodeGroup>
   </CodeGroup>
.
.
.
   <CodeGroup>
   ..
   </CodeGroup>
  </CodeGroup>
</CodeGroup>

SQL Server 2008 R2 Reporting Services 

SmartCodeDeveloper.dll will need to be copied to the [MSSQLServer2008R2InstallDir]\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin directory of SQL Server 2008 R2. The default directiory is C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin.

rssrvpolicy.config
This is the Report Server policy configuration file.The default path for this file is [MSSQLServer2008R2InstallDir]\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rssrvpolicy.config. The following tag will need to be added to the rssrvpolicy.config file. It grants SmartCodeDeveloper FullTrust permission to run in Report Server.

<CodeGroup class="UnionCodeGroup" Name="SmartCodeDeveloperControl" version="1" PermissionSetName="FullTrust" Description="This code group grants SmartCodeDeveloper.dll FullTrust permission.">
<IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin\SmartCodeDeveloper.dll"/>
</CodeGroup>


Note : You might see several existing <CodeGroup> tags. The recommended place to put the above tag will be immediately after the one with Url="$CodeGen$/*"