SQL Server Configuration Manager could not connect to the WMI provider _mssql

You can't open SQL Server today. An error was reported, and then I opened SQL Server Configuration Manager and I saw this error as shown below.

Then went to the Internet to search the solution to the problem, combined with the following several:

First type:

Network The service Read permission to the database program.

C:/Program files/microsoft SQL server/90/shared Add Network Service privileges or user permissions to this directory, and of course you can add everyone.

This method I do not know how to operate, will not add.

The second type:

Check to see if there is a FrameDyn.dll system file in the System32 under Windows, if you don't copy FrameDyn.dll to the System32 directory under System32 WBEM files. I went into the system32 directory to find FrameDyn.dll file, did not find, and then into the System32/wbem directory, find FrameDyn.dll, copy to System32.

I have this framedyn.dll file in the original, so this method is not valid for me.

The third type:

Start running Cmd.exe into command line

Enter the installation directory Cd/program Files/microsoft SQL server/90/shared

Enter Mofcomp "C:/Program files/microsoft SQL server/90/shared/sqlmgmproviderxpsp2up.mof"

The exact path depends on your SQL installation path.

The results of the implementation are generally as follows

Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file:c:/program Files/microsoft SQL server/90/shared/sqlmgmprovider
Xpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository ...
done!

On servers, the. mof file would be sqlmgmprovider.mof.

Note that if you are prompted to execute the second command, ' Mofcomp ' is not an internal or external command, it is not a running program or a batch file.

Right-click My Computer on the desktop-Properties-advanced options-environment variables-System variables edit in path in the back add:%systemroot%\system32\wbem; ok.

I did, but it didn't solve the problem.

Tip: C:/Program files/microsoft SQL server/90/shared/sqlmgmproviderxpsp2up.mof not found

The fourth kind:

1 Right-click "My Computer"--> "Management"
2 Double-click on the Administrators group in local Users and groups, and the Add Properties dialog box appears.
3 Click the Add button and the Add User dialog box appears
4 Click the Advanced button, and then click the Search (or Find Now) button. Note: This ' NT authority\network SERVICE ' user is a built-in account for the system and cannot be added directly.
5 After you select the network Service user in search results, click OK

The fourth type is the easiest to operate, and I think the easiest way. The problem, however, is still there.

Finally, I turned on SQL Sever's two services, SQL Server and SQL Server Browser services
Probably because it's been too long to use SQL Server, these two services are not open. SQL Server can be turned on or used after two services have been opened.
Hope that in the future in the face of this problem can be resolved through these several methods smoothly.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.