Fixed: DPM could not enumerate sql server instances using windows management instrumentation

Problem

We are using DPM 2012 to backup our SharePoint 2010 farm using the SharePoint connector in DPM (not SQL backups). I ran the configuresharepoint.exe -enablesharepointprotection followed by configuresharepoint.exe -resolveallsqlaliases (we are using SQL aliases) on one of our Web Front End Servers as required. I then verified that the SharePoint VSS Writer service was Started and running under the account I had specified using configuresharepoint.exe.

I then proceeded to add the server to our SharePoint Protection Group. When I clicked on server to select the SharePoint farm, DPM threw up the following error:

DPM could not enumerate SQL Server instances using Windows Management Instrumentation on the protected computer dbserver.example.com

We are running Windows Server 2008 R2 and SQL Server 2008 R2 as our database server.

Solution

In order to fix the error:

  1. Login to your database server
  2. Open Command Prompt and browse to C:\Program Files (x86)\Microsoft SQL Server\100\Shared
  3. Run the command: mofcomp sqlmgmproviderxpsp2up.mof

You should see the following message:

Microsoft (R) MOF Compiler Version 6.2.9200.16398
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!

Now go back to your DPM server and try to add your SharePoint farm. The error should no longer appear.

 

Tags: ,

2 Responses to “Fixed: DPM could not enumerate sql server instances using windows management instrumentation”

  1. john May 5, 2015 at 12:25 am #

    Probably A’m are stiupid but….
    For instalation SQL Server i must use fire from SQL server….

Trackbacks/Pingbacks

  1. SQL Auto Protection Fails | Michael Phillips Blog - June 6, 2013

    […] http://www.mysharepointadventures.com/2013/01/fixed-dpm-could-not-enumerate-sql-server-instances-usi… […]

Leave a Reply

%d bloggers like this: