Issue
Problems upgrading/installing SQL server.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine XXXXXXX Error:2147749896 (0x80041008).
"Not clustered or the cluster is up and online” check fails.
Note: In the screen shot above the clustering check was passed.
Environment
TAC Vista 5.X.X
SQL Server 2000/2005/2008 all versions; upgrades and new installations.
Cause
The WMI (Windows Management Instrumentation) Control is a tool that enables you to configure WMI settings. Inadequate access permission will mean that the user is unable to access the WMI service.
Resolution
If one of these messages appears or other problems are encountered during installation or upgrading of an SQL server, follow the steps below:
1. Check the WMI settings
- Go to My Computer – either in the start-menu or go directly to the desktop icon if running windows in classic mode – and right-click on it. Select Manage.
- In the hierarchical tree in the pane to the left, expand Services and Applications.
- Locate WMI Control and right-click on it. Select Properties from the context-menu.
If the message “Failed to initialize all required WMI classes” is displayed (see screenshot below) read on…
2. Change/check the DCOM settings
- Open the start-menu, click on Run and type “dcomcnfg”. The Component Services console should open.
- Expand Component Services and then expand the Computers folder.
- Select and right-click on My Computer.
- Select Properties.
- In the dialogue window that opens up select the COM Security tab.
- Under Launch and Activation Permissions select Edit Default.
- Check under Groups or user names to see if the group Everyone has been added. If not select Add, type in "everyone" and then click on Check names. Once the name is confirmed, click on OK.
- Ensure that the permissions Local Launch, Local Activation and Remote Activation are allowed for the group Everyone.
- Repeat the above steps for Launch and Activation Permissions but select Edit Limits.
- Click on OK again to close the My Computer Properties window and then close Component Services.
- Go back to the Computer Management console described earlier and locate WMI control under Services and Applications. Right-click on it and select properties.
- If all the steps have been followed the message should read "Successfully connected to local computer." After this it should be possible to upgrade/install SQL server.
