SQL Database Upgrade process-solve the WMI Service cannot be linked process, sqlwmi

Source: Internet
Author: User

SQL Database Upgrade process-solve the WMI Service cannot be linked process, sqlwmi

The trial period of the previously used SQL SERVER database is reached, and the database cannot be opened, prompting that the database has no permissions.


I believe many people have encountered this error, and there are also many solutions. You can find some preliminary work on the Internet.

Next let's talk about my solution: first understand what WMI is, which is taken from Baidu Encyclopedia: WMI, the core of Windows 2 K/XP management system; for other Win32 operating systems, WMI is a useful plug-in. WMI is based on CIMOM. CIMOM is the Common Information Model Object Manager. It is an Object database that describes the components of an operating system, provides a public interface for MMC and script programs to access the operating system components. With WMI, different APIs are not required when tool software and script programs access different parts of the operating system. On the contrary, WMI can be inserted into different parts of the operating system.

Step 2: Check whether the WMI service is enabled: win + R -- enter service. mrc, open the service -- find the WMI service -- and check whether the service is enabled.


Step 3: win + R -- Enter cmd -- enter mofcomp "C: \ Program Files (x86) \ Microsoft SQLServer \ 100 \ Shared \ sqlmgmproviderxpsp2up. mof (here is sqlmgmproviderxpsp2up in the shared folder under the installation directory of the SQL database. mof path. My shared path is under the 100 directory.) "-- press enter to run. If the problem is solved, congratulations. If the problem is not solved, go to step 4. The third step cannot be completed because it does not have the permissions of the Network Service user. Next, add the permissions to it.

Step 4: Right-click my computer-properties-advanced system settings-system properties-Environment Variables



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

Step 2: Find framedyn. dll in the wben folder, right-click Properties> Security> edit under permission> Add> advanced> Search all> select NetworkService, and click OK.





Re-Execute Step 1 to obtain the following results:


Through comparison, the above failed result is the result before steps 4th and 5. After steps 4 and 5 are added, the correct result is obtained. Open the SQL Configuration Manager below:


It can be opened smoothly without so many troubles. This process is a complete conclusion.

My biggest achievement is to find a method and handle it according to your specific error. I searched for a long time on the Internet and found that the four methods are the same. At the beginning, I did the same operation according to the method, but it failed because framedyn is not in my wbem folder. dll files, which are the opposite of the errors mentioned on the Internet, and the shared folder under my SQL is under 100, and some solutions on the Internet are on 90 and on 110, they are not the correct solutions to their own problems. Through comparative analysis of these methods, we finally found that the solution is in line with our own method. This process also gives you confidence in solving problems and has accumulated experience.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.