[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
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\Wow6432Node\Microsoft\Microsoft SQL Server
HKLM\Software\Wow6432Node\Microsoft\Microsoft SQL Server Compact Edition

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.

Vinayak SP
[SOLVED] Microsoft SQL Server Failed to Install or Reinstall | Repair & Install SQL Database
4/ 5 stars - "[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 versi...

Amazon Great Indian Festival Sale

[From 17th to 20th Oct]
Amazon in Offers on Clothing Clothing & Accessories Todays Deals Great Savings Every Day
Prev Story
Next Post »
Read & Post Comments


All of the ProBlogBooster ideas are free for any type of personal or commercial use. All I ask is to keep the footer links intact which provides due credit to its authors. From time to time, we may use customer information for new, unanticipated uses not previously disclosed in our privacy notice. If our information practices change at some time in the future we will post the policy changes to our Website to notify you of these changes and we will use for these new purposes only data collected from the time of the policy change forward. If you are concerned about how your information is used, you should check back at our Website periodically. For more about this just read out Privacy Policy


Articles on Writing Unique Content

Making Blogger Responsive Mobile-friendly Template
Learn More About Responsive Web Development

Top 15 Must-Have Apps You Should Install
Right After Buying A New Smartphone

Making Blogger Responsive - How to make, design and build a responsive blogger template. This is an advanced tutorial & tep-by-step guide for making mobile-friendly responsive blogger HTML template compared to responsive web development. [Read More...]
These are the best android and iOS apps you need to consider and install right after buying a new smartphone to make your life easier. These apps will keep you smartphone as like new and boost mobile performance regularly. [Read More...]