Support for running Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008

This article describes support for running Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008.

Microsoft Dynamics CRM 4.0 is compatible with Microsoft SQL Server 2008. The Microsoft Dynamics CRM client for Microsoft Office Outlook with Offline Access is compatible with SQL Server 2008 Express Edition. Microsoft Dynamics CRM Data Migration Manager is compatible with SQL Server 2008.

Note Microsoft Dynamics CRM 3.0 and the Microsoft Dynamics CRM 3.0 client for Microsoft Office Outlook are incompatible with SQL Server 2008.

Microsoft Dynamics CRM 4.0 supports the following versions of SQL Server 2008:

• SQL Server 2008 Enterprise Edition (32-bit and x64)
• SQL Server 2008 Standard Edition (32-bit and x64)

Note If you use the Microsoft Dynamics CRM client for Outlook with Offline Access and Microsoft Dynamics CRM Data Migration Manager, SQL Server 2008 Express Edition is also supported.

To install Microsoft Dynamics CRM 4.0 so that it runs together with Microsoft SQL Server 2008, you must install the following hotfixes:

• Hotfix 952601
  For more information, click the following article number to view the article in the Microsoft Knowledge Base:
  952601  (http://support.microsoft.com/kb/952601/ ) Error message when the Setup program for Microsoft Dynamics CRM 4.0 performs a check in the Environmental Diagnostic Wizard (EDW): "Error| Check FullTextRunningValidator : Failure: Service msftesql was not found on computer '[Computer_Name]'"
• Hotfix 952602
  For more information, click the following article number to view the article in the Microsoft Knowledge Base:
  952602  (http://support.microsoft.com/kb/952602/ ) Error message when you try to install Microsoft Dynamics CRM Data Connector for Microsoft Dynamics CRM 4.0: "Unable to validate SQL Server Reporting Services Report Server installation"
• Hotfix 947278
  For more information, click the following article number to view the article in the Microsoft Knowledge Base:
  947278  (http://support.microsoft.com/kb/947278/ ) Error message when you try to install the Microsoft Dynamics CRM Connector for SSRS: "Microsoft Dynamics CRM Connector for SSRS Setup Setup did not complete successfully"

To install these hotfixes, you can click Update installation files during the installation of Microsoft Dynamics CRM 4.0 and the Microsoft Dynamics CRM 4.0 Connector for SQL Server Reporting Services. You can also follow the steps that are described in Microsoft Knowledge Base article 948917.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

Issues that may occur after you install Microsoft Dynamics CRM 4.0

Before you install Microsoft Dynamics CRM 4.0 so that it runs together with Microsoft SQL Server 2008, you must make sure that the SQL Full-text Filter Daemon Launcher service is started. If the service is not started, the Knowledge Base search function will not work after you install Microsoft Dynamics CRM 4.0.

If you use the Microsoft Dynamics CRM Connector for SQL Server Reporting Services, reports will not work after you upgrade SQL Server 2005 to SQL Server 2008. You must uninstall and then reinstall the Microsoft Dynamics CRM Connector for SQL Server Reporting Services.

If you try to create a new organization or if you try to import an organization after you upgrade SQL Server 2005 to SQL Server 2008, you will receive the following error message: If you receive this error message, you must install hotfix 956869.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

Issues that may occur when Microsoft Dynamics CRM 4.0 runs together with Microsoft SQL Server 2008

When you run Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008, one or more of the following issues m ay occur.

Issue 1

When the Setup program of Microsoft Dynamics CRM 4.0 performs a check in the Environmental Diagnostic Wizard (EDW), you receive the following error message: To resolve this problem, install hotfix 952601.

Issue 2

When you try to install Microsoft Dynamics CRM Data Connector for Microsoft Dynamics CRM 4.0 on a server that is also running Microsoft SQL Server 2008 Reporting Services, you may receive the following error message in the EDW: To resolve this problem, install hotfix 952602.

Issue 3

When you try to install the Microsoft Dynamics CRM Connector for Microsoft SQL Server Reporting Services (SSRS) in the SSRS server, you receive the following error message: To work around this problem, follow the steps that are described in Microsoft Knowledge Base article 947278.

Issue 4

When you search the Knowledge Base articles, you may receive the following error message: Additionally, no records are returned.

To work around this problem, follow these steps:

1. Start the SQL Full-text Filter Daemon Launcher service. To do this, follow these steps:
   1. On the computer that is running SQL Server 2008, click Start, click Run, type services.msc, and then click OK.
   2. Right-click SQL Full-text Filter Daemon Launcher, and then click Start.
2. Add the service account to the SQLServerFDHostUser$SQLSERVER$Instance local group. To do this, follow these steps:
   1. On the computer that is running SQL Server 2008, click Start, click Run, type compmgmt.msc, and then click OK.
   2. Expand Local Users and Groups, and then click Groups.
   3. Right-click SQLServerFDHostUser$SQLSERVER$Instance, and then click Add to Group.
   4. Click Add.
   5. In the Enter the object names to select box, type the user account that starts the SQL Full-text Filter Daemon Launcher service, and then click OK.
3. Rebuild the full-text catalog. To do this, follow these steps:
   1. On the computer that is running SQL Server 2008, click Start, click All Programs, click Microsoft SQL Server 2008, and then click SQL Server Management Studio.
   2. Expand Databases, expand Organization_Name_MSCRM, expand Storage, expand Full Text Catalogs, right-click the ftcat_documentindex_"GUID", and then click Rebuild.
   3. Click OK to delete the full-text catalog and to rebuild the full-text catalog.
   4. Click Close.

Issue 5

When you try to create a new organization or when you try to import an organization, you receive the following error message in the EDW: To resolve this problem, apply hotfix 956869.

Issue 6

When you install Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008 and SQL Server 2008 Reporting Services all on the same server, you may receive the following error message: This issue occurs when the path of Reporting Services does not exist on the server.

To work around this issue, create a Web site that runs on the same port and the same URL that the Reporting Services server is using. In SQL Server 2008 Reporting Services, IIS is not used for accessing reports. However, if Microsoft Dynamics CRM 4.0 is installed on the same server, Microsoft Dynamics CRM 4.0 must find a Web site that has the same URL to bypass the error. To verify the URL of Reporting Services, follow these steps:

1. Click Start, click All Programs, click Microsoft SQL Server 2008, click Configuration Tools, and then click Reporting Services Configuration Manager.
2. Click connect to connect to your report server instance.
3. Click the Web service URL, and see what the report server Web service URL is. For example, the URL may be http://SQLServername:8181/ReportServer.

In Windows Server 2008, follow these steps:

1. Click Start, click Run, and then type inetmgr.
2. Expand the server name, right-click Sites, and then click Add Website.
3. Enter a name for the site, and then select a physical path.
4. Enter the port number of the report server Web service. For example, enter 8181.
5. Click OK.

In Windows Server 2003, follow these steps:

1. Click Start, click Run, and then type inetmgr.
2. Expand the server name, right-click Web Sites, click New, and then click Web Site.
3. Enter a description for the site, and then click Next.
4. Enter the port number of the report server Web service. For example, enter 8181, and then click Next.
5. Enter a path for the Web site, and then click Next.
6. On the Permissions page, click Next.
7. Click Finish.