[SOLVED] Microsoft SQL Server Failed to Install or Reinstall | Repair & Install SQL Database

Finally, I got the solution on how to install or re-install Microsoft SQL Server including any version such as MS SQL Server Management Studio 2008 or the latest SQL Server 2012 Management Studio. Initially, the installation was getting failed when you are trying to install SQL setup as well as even you are trying to reinstall the same copy of SQL setup on the same server. And the reason I found is at the files that are partly failed to installed or left behind there even when you uninstalled the first copy, the integrated security SQL server files still exist on the same server and they are not allowing new installation. So I decided to clean it from scratch, but cleaning is also get failed. Most of the technical people suggest formatting the operating system. And that is exactly what I don't want to do with my Windows operating system. Then I find the best cleaner and try to reinstall and finally I succeeded after lots of troubleshooting. And as I searched and got to know that many of you would have seen this issue when trying to install SQL Server 2008/2008 R2/2010/2012/2014 setup file on the new server, so I decided to share the procedure to save your time.

Typically, this problem occurs significantly and the solution employs to Microsoft SQL Server Express [SQL Server 2008 R2], Microsoft SQL Server Developer, Microsoft SQL Server Express with Advanced Services, Microsoft SQL Server Enterprise Evaluation, to install SQL database for Microsoft SQL Server Standard, Microsoft SQL Server 2008 R2 Datacenter, Microsoft SQL Server 2008 R2 Developer, SQL Express 2012, Server Management Studio, SQL Server Management Studio Client, Microsoft SQL Server Web, Microsoft SQL Server Workgroup, SQL Management Studio x64, Microsoft SQL Server Developer, Microsoft SQL Server Standard Edition for Large/Small Business, Microsoft SQL Server Enterprise and SQL Management Studio 2012. Learn how to fix and solve the problem in SQL Server installation at Windows.

SQL Server Failed to Install or Reinstall - Install SQL Database.jpg

Last time we have seen; how to fix Installation Failure Error Codes 0x80246007, 0x80246008, 800b0100 | Can't Install Microsoft Windows 10 Update, and today we are again going to see something interesting and most critical error for MS SQL installation.

Also check: 5 Ways How Wearable Technology Will Improve Our Daily Life

Fix SQL Server Installation or Reinstallation Failed Errors

On the Windows operating system, some users like to remove default user rights to the local administrators in order to tighten the integrated security SQL server. And to install Microsoft SQL, they furthermore add the setup account to the local administrator group. And that is why your set up SQL server 2012 management studio or any, the installation or reinstallation process gets failed even if you either upgrading or install SQL database. So to overcome the errors you have to clean your PC for fresh SQL installation.

1. Repair a failed installation of SQL Server

Run the following command in command prompt:
Setup.exe /q /ACTION=Repair /INSTANCENAME=instancename

2. Uninstall SQL Server Express

Go to START >> Control Panel >> Add or Remove Programs >> Select Microsoft SQL Server 2005 >> REMOVE

Also, you need to remove SQL Server 2005 instance components and workstation Components as well.

Now go to START >> Control Panel >> Add or Remove Programs >> Microsoft SQL Native Client >> REMOVE.

3. Completely Uninstall SQL server

Delete the following folders:

C:\Program Files\Microsoft SQL Server
C:\Program Files (x86)\Microsoft SQL Server

Run >> regedit, and delete the following registry keys:
HKLM\Software\Microsoft\Microsoft SQL Server
HKLM\Software\Microsoft\SQMClient
HKLM\Software\Wow6432Node\Microsoft\Microsoft SQL Server
HKLM\Software\Wow6432Node\Microsoft\Microsoft SQL Server Compact Edition
HKLM\Software\Wow6432Node\Microsoft\MSSQLServer
HKLM\Software\Wow6432Node\Microsoft\SQMClient

4. Remove a broken installation of SQL Server By uninstall tool.

This is one of the best way, and most of the users are felt too much easy to use this. You need to download IObit Uninstaller.
Run the program, and select Microsoft SQL Server 2008 R2 [as per your install sql database] and click UNINSTALL. Now it will remove all and then it will show the option for POWERFULL SCAN. Click on it and it will show all the registry entries related to the server management studio. Select all and delete. Restart PC. And now check the installation.

If you know any other better way to do this and if you think that will help others too then you may share it via comments, we would glad to add it on this page directly.