CRM 2011 : SQL Server Supported Versions

Microsoft Dynamics CRM 2011 is not supported on SQL Server that is running on Windows 2000 Server, and also not supported for Windows 2003/R2 and Windows 2008/R2 32 bit.

If the installation is done in a SQL Server 2008 on a Windows 2008r2 Server, and then if we move CRM databases to another server with SQL Server 2008 in Windows 2003r2, this is also not supported.

The recent version of SQL Server 2012 is also supported for the Dynamics CRM 2011.

Cannot connect to WMI provider – Sql Server Configuration Manager 2008 R2

Reason :

This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server 2008. The 32-bit instance and the 64-bit instance of SQL Server 2008 share the same WMI configuration file. This file is located in the %programfiles(x86)% folder not in the %programfiles% folder which is used for 64 bit.

Resolution:

Goto ‘Start’ – ‘All Program’ – ‘Accessories’, right click on ‘Command Prompt’ and select ‘Run as Administrator’.

mofcomp “%programfiles(x86)%\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”

Note For this command to succeed, the sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\100\Shared folder.

TIP: Whenever you run ‘Command Prompt’, always ‘Run as Administrator’.

Case CLOSED!