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.

Microsoft Internal Support Information

Steps to reproduce.

Product Bug Number:
Author ID (email alias):
Writer ID(email alias):
Tech Review ID (email alias):
Confirm Article has been Tech Reviewed: Yes/No
Confirm Article released for Publishing: Yes/No
Properties

Article ID: 2719717 - Last Review: Jun 18, 2012 - Revision: 1

Feedback