Saturday, June 07, 2008

Solutions for SQL Server 2005 Install Errors

Error 29521:
1. Make sure the date and time are accurate.

Error 29503:

1. Ensure your system meets the requirements
2. Remove all SQL components from Add/Remove Programs
3. Download the Windows Installer Cleanup and remove any SQL entries
4. Remove the following folders:
C:\Program Files\Microsoft SQL Server
XP: %USERPROFILE%\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data
Vista: %USERPROFILE%\AppData\Local\Microsoft\Microsoft SQL Server Data

5. Open regedit and go to HKLM\System\CurrentControlSet\Services and delete any "MSSQL..." and "SQL..." keys. Also delete:
HKLM\Software\Microsoft\Microsoft SQL Native Client
HKLM\Software\Microsoft\Microsoft SQL Server
HKLM\Software\Microsoft\Microsoft SQL Server 2005 Redist
HKLM\Software\Microsoft\MSSQLServer

6. Restart and disable your firewall
7. Reinstall

Error 29515:
1. Import this registry file and reinstall

WMI check failed:
1. Copy the following lines into a "fixwmi.cmd" file and run it (As Administrator in Vista)

@echo on
cd /d c:\temp
if not exist %windir%\system32\wbem goto TryInstall
cd /d %windir%\system32\wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End

:FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /RegServer

:SkipSrv
goto End

:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End

COM+ Catalog Check Failed:
1. Open a command prompt (right-click and run as admin under Vista)
2. Run the command msdtc -uninstall
3. Run the command msdtc -install

"Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance"
1. Restart
2. Delete the appropriate folder from within:
XP: %USERPROFILE%\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data
Vista: %USERPROFILE%\AppData\Local\Microsoft\Microsoft SQL Server Data

If that doesn't work, repeat the above and then:
3. Go the SQL Server Configuration Manager and stop the service for your database.
4. Change the login to "Local System" and start the service.

No comments: