Microsoft KB Archive/918841

= How to manually connect SQL Reporting Services (SRSS) to Microsoft Dynamics CRM 3.0 =

Article ID: 918841

Article Last Modified on 8/9/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-





SUMMARY
Consider the following scenario:
 * You try to install SQL Reporting Services (SSRS) for Microsoft Dynamics CRM 3.0.
 * The Environment Diagnostic Wizard fails.
 * You click Ignore.

In this scenario, Reporting Services does not install.

Notes

When you open forms or list views that contain the icon that you can use to generate reports, you may experience slow performance. This behavior indicates that Reporting Services is not installed or that Reporting Services is not connected to Microsoft Dynamics CRM.

The version of Reporting Services that is included on the Microsoft CRM 3.0 installation CD works only with Reporting Services for Microsoft SQL Server 2000.



INTRODUCTION
This article contains steps to install Reporting Services and steps to manually connect Reporting Services to Microsoft Dynamics CRM.



MORE INFORMATION
To manually connect Reporting Services to Microsoft Dynamics CRM, follow these steps:  On the Microsoft CRM 3.0 installation CD, double-click the Setup.exe file, and then follow the instructions that appear on the screen. The Setup.exe file is located in the following folder:

\SRS

 Install Service Pack 2 (SP2) for Reporting Services. To do this, locate and then double-click the SP2Setup.exe file. The SP2Setup.exe file is located in the following folder:

\SRS\sp2setup_1033

 Use the rsconfig tool to configure the Report Server instance to use the correct Report Server database. To do this, run the following command at the command prompt:

rsconfig -c -s  -d   -a windows

Notes  In this command,  represents the name of the actual Report Server instance, and   represents the name of the actual database. The rsconfig tool is located in the following folder:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn

 For more information about the rsconfig tool, run the following command at the command prompt:

rsconfig /?

</li></ul> </li> Publish the reports. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Open the Command Prompt window. At the command prompt, open the Reports folder by using the following path:

c:\program files\microsoft crm\reports

</li> At the command prompt, run the following command:

publishreports.exe &quot; &quot; &quot; \reportinggroup &quot;

Note In this step, substitute the appropriate values for, for  , and for.

</li></ol> </li> Give the reports the correct permissions. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> On the default Web site where Reporting Services is installed, open the Reports folder by using the following path:

http:// /reports

</li> Click Properties. Then click the _mscrm folder.

Note In this step,  represents the company name that you entered during the Microsoft CRM installation.

</li> Click the Security tab.</li> Add the following groups by using the specified roles: <ul> BUILTIN\Administrators: Content Manager</li>  \ReportingGroup : Browser for Microsoft CRM</li> NT AUTHORITY\NETWORK SERVICE: Publisher for Microsoft CRM</li></ul>

Note If any of these groups are missing, you must add the missing groups. To add groups to Reporting Services, follow these steps: <ol> On the Security tab, click New Role Assignment.</li> In the Group field or in the User name field, type \REPORTINGGROUP.

Note In this step, substitute the appropriate values for  and for  .</li> Click to select the Browser for Microsoft CRM check box. Then click OK.</li> Repeat steps 1 through 3 for any missing groups. Give the NT AUTHORITY\NETWORK SERVICE group the &quot;Publisher for Microsoft CRM&quot; role, and then give the BUILTIN\Administrator the &quot;Content Manager&quot; role.

Note If the Microsoft CRM server is running on Windows 2000 Server, you must add the computer account to the security settings for the _mscrm folder.</li></ol> </li></ol> </li> Copy the style sheets for Microsoft CRM reports to your Reporting Services installation. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Copy the Mscrm.css file, the Mscrmx.css file, the Mscrmp.css file, and the Mscrmxp.css file from the Microsoft CRM Server CD to the styles folder of your Reporting Services installation. These files are located on the CD in the following folder:

wwwroot\CRMReports\rsstyles

By default, the path of the styles folder is the following path:

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\styles

</li> <li>Select all four files.</li> <li>Right-click the selected files. Then click Properties.</li> <li>Click the Security tab. Then click Add.</li> <li>Type. Then click OK.

Note In this step,  is a placeholder for an Active Directory group that includes all Microsoft CRM users.

</li> <li>Modify the permissions for  so that in the Allow column, only the Read permission is selected. Then click OK.</li></ol> </li></ol>

<div class="references_section">