Error:
SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt. Error 29506.
Error Message:
Causes:
- Run the SQL Server setup as Run as Administrator. Administrator priviliges is required to install SQL Server.
- Windows management instrumentation service might be corrupted.
- Components or files related to WMI service might be unregistered or missing.
- The main cause of the above error is that there are improper permissions of the DATA and LOG folder of the SQL server 2005.
Workaround 1:
Make sure that you are running the SQL Server setup as “Run as Administrator”.
Workaround 2:
Give Full control permissions to “EVERYONE” for [C:\Program Files\Microsoft SQL Server]
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:
Download the attached file and execute the batch file.
Re-install SQL server express 2005 again.
Download: SqlWmiFix.bat
Workaround 6:
Click Start | Run | type regedit | Click OK.
Navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\ UserData\S-1-5-18\Components.
Right-click on and select “Permissions”
In the “Permissions for Components” screen that comes up, click the Advanced button.
In the “Advanced Security Settings for Components” screen that comes up, click the “Owner” tab.
In the “Owner” tab, check the “Replace owner on subcontainers and objects tickbox, select “Administrators” and click Apply.
Workaround 7:
Remove Microsoft 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
