System Center Service Manager installation fails with SQL version related error


Symptoms


While either installing a fresh copy of System Center 2012 Service Manager or while upgrading, you receive the following error message after specifying the SQL server to host the Service Manager database:

The SQL Server name is not running version SQL Server 2008 SP2 or SQL Server 2008 R2. Please update it to the newest version and retry.

NOTE The server in question already has SQL 2008 R2, SP2 or higher installed.

Cause


This can occur if there is an issue with the SQL MOF file.

Resolution


To resolve this issue, recompile the MOF:

1. Open a command prompt with Administrator rights on the SQL server where you want to install the Service Manager databases.

2. Change to the following directory:

C:\Program Files (x86)\Microsoft SQL Server\100\Shared>

3. Once at this location execute the following command:

mofcomp sqlmgmproviderxpsp2up.mof

The successful completion of the above command should generate output similar to the following:

Microsoft (R) MOF Compiler Version 6.1.7600.16385
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository...
Done!

Once complete, restart the Service Manager installation.