A couple of days back I had my computer formatted. I reinstalled it with Vista SP1 32bit. Subsequent to installing other indispensable software I tried to install SQL Server 2005 . However, it instantly displayed the following error message.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008).
It was a bit frustrating for me as it was pretty late and I ardently wanted to install SQL Server 2008 right after I was done with installing SQL Server 2005. I pinged my friend James Locazicoski with the above error message. James came to my rescue with a batch file. I immediately ran the batch file on my server; it took a while and when it was done it closed itself on vista. I kept my fingers crossed and ran my SQL Server installer right after that. There was no WMI error to wreck my nerve. I was able to successfully install SQL Server right after that.
Well, this bat file is certainly a life savior. While searching online I found this script at several places, which reflects its popularity and usability. I need help from my readers regarding the following information.
1) Where is the original source of this script?
2) What is this script actually doing?
Once I receive response to both the above questions, I will post the answers on my blog with due credit to my readers.
Download Batch File Here
Reference : Pinal Dave (https://blog.sqlauthority.com)
44 Comments. Leave new
It works, Thanks
thanks a lot.
Worked Thanks!
Check out the repair script on Lansweeper.com (point 7) on this page:
It fixed my problem when contacting Lansweeper support.
It looks like it’s doing a full repair of all WMI libraries and classes.
Hi Pinal
I was suffering with this while I am trying to install sql server 2008 r2 in windows 7. there error was like this
sql server has encountered the following error:
could not load file or assembly, 0 bytes loaded from system, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089 or one of its dependencies. an attempt was made to load a program with incorrect format.
error code:0x84B10001.
thanks dude , i was really suffer from this problem but b’coz of u’r a download batch file ..& it woks for XP
Awesome Batch file! It Fixed my problem first try. Thanks!
I got the error–Could not find a package to install on the installation media while installing sql server 2005 on windows xp.
I ran the FIXWMI.cmd as u told, but after i run for a while, it says go to end then auto shut down.
How should I solve it?
I am also having a problem in installing SQL Server 2008 R2, WMI fails, I executed the batch, and re run the Set up Support Rules part but it doesn’t work. I tried : net start winmgmt in command prompt, then it shows service name is invalid with message more help is available by typing NET HELP MSG 2185 .. after I executed this shown command I got a message : check the spelling of the service or check the configuration information for the
service using the Service option from Server Manager. Any help will be appreciated .. thanks
Thanks a lot
One word:
P.E.R.F.E.C.T
Script Worked for me.
thanks… it works… but, im concern if this is really a virus? thanks
Thanks Pinal, I’m stuck trying to resurrect an ancient application PC, and this is just the thing I need. Cheers!
Works for me too
Thanks
thanks brother
its work for me
Please help me to fix this error
TITLE: SQL Server Setup failure.
——————————
SQL Server Setup has encountered the following error:
Could not load file or assembly ‘Microsoft.VisualC, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The system cannot find the file specified.
Error code 0x84B10001.
For help, click: https://www.microsoft.com/en-us/?ProdName=Microsoft SQL Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xC70D84C9%400x2FCB8C55
——————————
BUTTONS:
OK
——————————
Can I just say THANK YOU for this batch file? I’ve been pulling my hair out with this error when trying to uninstall SQL Server 2005 and this has saved my day.
You are always welcome!