Error:
There was an unexpected failure during the setup wizard. You may review the setup logs and\or click the help button for more information.
Error Message:
Causes:
- Logged on user may not be an Administrator.
- Make sure you are running the setup as Administrator.
- Windows management instrumentation service might be corrupted.
- Improper uninstallation of SQL Server. Completely remove all the remaining components of previous installations SQL Server and then reinstall. Use Windows Installer cleanup utility.
- These errors occur when the Windows installer cannot have sufficient permission to run the installation.
- These errors occur when the Windows installer cannot create, read, or write the necessary entries.
Workaround 1:
Log off current user and logged in as Administrator. Make sure that you are running the SQL Server setup as administrator.
Workaround 2:
Download the attached file and execute the batch file.
Re-install SQL server express 2005 again.
Download: SqlWmiFix.bat
Workaround 3:
Modify the registry entry:
Click Start | Run | type regedit | Click OK.
Navigate to:
“HKEY_USERS\S-1-518\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders”
Right click on AppData | Click on Modify and type “%USERPROFILE%\Application Data”
Click OK.
Workaround 4:
Modify the registry entry:
Click Start | Run | type regedit | Click OK.
Navigate to:
“HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders”
Right click on AppData | Click on Modify and type “%USERPROFILE%\Application Data”
Click OK.
Workaround 5:
Remove SQL Server 2005 completely from Control panel
Control Panel | Add or Remove Programs | Microsoft SQL Server 2005
In the first dialog, make sure to select the “RELYONDB: Database Engine” radio button.
If RELYONDB is the only instance, then select all check boxes & Click Next and Finish to proceed with the uninstall.
If there is no other SQL instance, I would go on to clean out all SQL components with the following steps.
Uninstall Microsoft SQL Server Native client
Uninstall Microsoft SQL Server Setup support files
Uninstall Microsoft SQL Server VSS writer
