This article helps you fix an issue where you can't specify the SQL Server to host the Service Manager database when you install or upgrade System Center 2012 Service Manager.
Original product version: System Center 2012 Service Manager
Original KB number: 2719717
Symptoms
While either installing a fresh copy of System Center 2012 Service Manager or upgrading System Center 2012 Service Manager, 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 Server 2008 R2, SQL Server 2008 SP2, or a later version installed.
Cause
This issue can occur if there is an issue with the SQL Server MOF file.
Resolution
To resolve this issue, recompile the MOF file:
-
Open a command prompt with Administrator rights on the SQL Server where you want to install the Service Manager databases.
-
Change to the following directory:
C:\Program Files (x86)\Microsoft SQL Server\100\Shared -
At this location, execute the following command:
mofcomp sqlmgmproviderxpsp2up.mofThe 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.
Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.
