SQL Express is not installed properly. Steps to be taken before reinstall again

To verify the SQL Server Express instance installed, you could use Microsoft SQL Server 2008 Setup Discovery Report. For more information, please see http://blogs.msdn.com/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx

If the Setup Discovery Report doesn’t list the SQL Server Express instance, try the following steps to reinstall it:
1. Make sure you have administrative rights on the computer
2. Uninstall the existing SQL Server 2008 and all the components from the control panel. Remember to backup the user databases before uninstalling SQL Server.
3. Backup the registry.
4. Delete the following keys in regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
5.  Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server.
6.  Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
7.  Rename all the SQL Server folders in the computer.
8.  Download and install Windows Cleanup Utility:
Run the utility and remove any SQL Server components that you find.
9. Reboot the machine
10. Download and install Microsoft .Net Framework 3.5 SP1:
11. Download and install Windows Installer 4.5. (Windows 7 has Windows Installer 4.5)
12. Check if the computer has Visual Studio 2008.  If so, you need to install Visual Studio 2008 SP1. For more information, please see http://support.microsoft.com/kb/956139
13. Download  SQL Server 2008 Express Edition Service Pack 1 and install it:
If it still fails, please provide us the error messages logged into the setup log files which are located in the %Program files%\Microsoft sql server\100\Setup bootstrap\Log\ folder. For more information about how to View and Read SQL Server Setup Log Files, please see http://msdn.microsoft.com/en-us/library/ms143702.aspx.

Comments (8)

  1. Can says:

    Bozuk Sql Server' ı kaldırmak için çalıştığı garantili yöntem.

  2. Frans says:

    Thank youuuu,…

    You are my life saver!

  3. Wonder says:

    It works out great! Thanks a lot!

  4. Zaheer Khan says:

    Thank you so much , it worked for me but after doing this i am again another error

    MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = ‘{8BDD006D-D5F0-4AAA-BA13-65995063EC44}’. Error code: 1608

  5. eyüp says:

    anasını sikiyim sqlserver kere. öyle dersiniz soranlara.çile aq

  6. Maximus says:

    Works out great, too! Thank you very much!

  7. shidaa nii-noi says:

    thanks man, u guys are the best out there


  8. Daniel says:

    Thank you very much, it worked!!

    The only problem was that  "Windows Cleanup Utility" is no longer supported by microsoft, but I searched for it and found it

Skip to main content