Frequent Errors during installation of CRM 4.0 with SQL 2008

  • Article

 

I am posting this blog, to share with you the errors that you usually face when installing CRM 4.0 with SQL 2008. I will write about the requirements, and the workaround to bypass these errors.

Architecture

  • 1 CRM Server ( Typical, web and app role)
  • 1 SQL Server (SQL Database and SRS)

CRM Server can be installed on windows 2008 R2, I recommend installing the features and roles from windows powershell as follow:

Add-WindowsFeature NET-HTTP-Activation,NET-Framework-Core,NET-Framework,NET-Win-CFAC,RSAT-ADDS-Tools,RSAT-AD-AdminCenter,RSAT-AD-PowerShell,RSAT-Web-Server,RSAT,RSAT-Role-Tools,RSAT-AD-Toolsm,RSAT-ADDS WAS-Process-Model,WAS-NET-Environment,WAS-Config-APIs,WAS

Application-Server,AS-NET-Framework,AS-Web-Support,AS-WAS-Support,AS-HTTP-Activation,File-Services,FS-FileServer,FS-Win2003-Services,FS-Indexing-Service,Web-Server,Web-WebServer,Web-Common-Http,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Http-Redirect,Web-App-Dev,Web-Asp-Net,Web-Net-Ext,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Health,Web-Http-Logging,Web-Log-Libraries,Web-Request-Monitor,Web-Http-Tracing,Web-Security,Web-Basic-Auth,Web-Windows-Auth,Web-Digest-Auth,Web-Client-Auth,Web-Cert-Auth,Web-Url-Auth,Web-Filtering,Web-IP-Security,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Mgmt-Tools,Web-Mgmt-Console,Web-Scripting-Tools,Web-Mgmt-Service,Web-Mgmt-Compat,Web-Metabase,Web-WMI,Web-Lgcy-Scripting,Web-Lgcy-Mgmt-Console

SQL server 2008 SP1 is needed when installing SQL Server on windows 2008 R2

Make sure that full text search, management tools, and Reporting Servers are selected during installation.

 

When installing CRM on the front end server, the installation verification fails and displays missing components msftesql and cisvc services. the reason is that msftesql (the sql server full text indexing service) has a different name against sql server 2008.

To workaround the msftesql issue:

  1. Just rename the registry key HKLM\System\CurrentControlSet\Services\MSSQLFDLauncher to msftesql to give an illusion to the MSCRM verification phase that services is present in the system so that it does not fail while installation.
  2. Now restart the system and run the installation of MSCRM again.
  3. After installation rename the HKLM\System\CurrentControlSet\Services\msftesql back to MSSQLFDLauncher.

To solve the cisvc services error, right click the MyComputer->Manage, now right click the Roles ->Add Roles and now install the file services role.

 

When installing Microsoft Dynamic CRM connector for SQL Server Reporting Service on the SQL Server, it fails. The only workaround for this issue is to choose the “Download latest update files” at the start of the setup.