SQL Database upgrade process-Resolve WMI service cannot link process

Before the trial period of the SQL Server database was used, the database failed to open, prompting for an error with no permissions.

This mistake believes that many people have encountered, the processing method also has many, the early work can find from the Internet.

Here's my approach: first understand what WMI is, the following excerpt from Baidu Encyclopedia:WMI, isWindows 2k/xpthe core of the management system;Win32operating system,WMIis a useful plugin. WMIinCIMOMas a basis,CIMOMthatPublic Information ModelObject Manager (Common information Model Object Manager) is an object database that describes the operating system composition unit,MMCand theScript Programprovides a common interface to access the operating system's constituent units. With theWMI,Tool Softwareand scripting programs to access different parts of the operating system, you do not need to use differentAPIinstead, different parts of the operating system can be insertedWMI.

Step two: Check WMI whether the service is open: Win+r --Input SERVICE.MRC , open the service-find WMI Service-Check if it is open.

Step Three:Win+r--Inputcmd--Inputmofcomp "C:\Program Files (x86) \microsoft Sqlserver\100\shared\sqlmgmproviderxpsp2up.mof(This isSQLIn the installation directory of the databasesharedfolder under theSqlmgmproviderxpsp2up.mofthe path to mysharedis in -directory)"--enter run. If this solves the problem, then congratulations, if not resolved, then look at the fourth step. The third step can not be completed by the role of noNetwork Servicethe user Rights, add permissions to it below.

Fourth step: Right-click on "My Computer"--Properties--Advanced system settings--System Properties--environment variables

Add the C:\Windows\System32\wbem path in path.

5th step: Find FrameDyn.dll under the Wben folder, right-click on Properties--security--Edit under Change permissions--add--advanced--Find all--select NetworkService , determined all the way.

re -Executing step 3rd, you can get the following results:

By contrast, the above failure is the 4th, 5 steps before the result, through 4, 5 steps to add permissions, and finally get the correct results. Open SQL Configuration Manager below:

will be able to open smoothly, there is no such a lot of annoying things. This process is a complete end.

My biggest gain is to find a way to deal with your own specific mistakes. I have been looking for a long time on the internet and found that the same 4 methods. At first I did it the way I did, but I didn't succeed, Because my WBEM folder does not have a FrameDyn.dll file, and the online error is the opposite, and my SQL under the shared folder is under 100, the online solution to some 90 on some 110, are not the correct way to solve their problems. It is through the comparative analysis of these methods, and finally found that the solution to the problem in line with their own methods. This process also exercises their own confidence to solve the problem, accumulated experience.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

SQL Database upgrade process-Resolve WMI service cannot link process