Shulou(Shulou.com)05/31 Report--

SQL Server configuration manager can not connect to the WMI provider how to do, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can get something.

I can't open sql server today. An error was reported, and then I opened the sql server configuration manager and saw the error shown in the figure below.

Then went to the Internet to search for solutions to this problem, which can be summed up in the following ways:

The first kind:

Just give the database program network service read permission.

C:/Program Files/Microsoft SQL Server/90/Shared can add network service permission or user permission to this directory, of course, you can add Everyone.

I don't even know how to operate this method. I won't add it.

The second kind:

Check to see if the system file framedyn.dll exists in the system32 under windows, and if you don't copy framedyn.dll to the system32 directory in the wbem file under system32. I went to the system32 directory to find the framedyn.dll file, and sure enough, I couldn't find it. I went into the system32/wbem directory, found framedyn.dll, and copied it to the system32 directory.

I already have this framedyn.dll file, so this method doesn't work for me.

The third kind:

Start running Cmd.exe to enter the 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 specific path depends on your SQL installation path.

The execution result is roughly as follows

Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.Parsing MOF file: C:/Program Files/Microsoft SQL Server/90/Shared/sqlmgmproviderxpsp2up.mofMOF file has been successfully parsedStoring data in the repository...Done!

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

Note that if you prompt when you execute the second command, 'mofcomp' is not an internal or external command, nor is it a runnable program or batch file.

Right-click on my computer-Properties-Advanced options-Environment variables-system variables in path and add:;% SystemRoot%\ System32\ Wbem; to OK on the desktop.

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

Hint: C:/Program Files/Microsoft SQL Server/90/Shared/sqlmgmproviderxpsp2up.mof not found

The fourth kind:

1 right-click "my computer"-> "Administration" 2 double-click on the Administrators group in Local users and groups, and the add Properties dialog box appears. 3 Click the add button, 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 and cannot be added directly. 5 after selecting the "Network Service" user in the search results, click OK

The fourth is the easiest to operate, and I think it's the easiest way to do it. However, the problem is still there.

Finally, I opened two sql sever services, SQL Server and SQL Server Browser services may be because I haven't used sql server for too long, these two services are not opened. After opening the two services, sql server can be opened or used. I hope that when we encounter this problem in the future, we can solve it smoothly through these methods.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.