Follow

SQL Server Configuration Error "Cannot connect to WMI provider" When Configuring Database for Installation

The error below pops-up when trying to configure local MSSQL Server 2014 Express edition to listen TCP/IP on port 1433.

"Cannot connect to WMI provider. You do not have permission or the server is unreachable"

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

To work around this problem, open a command prompt, type the following command, and then press ENTER:


mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"

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

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk