How to Fix SQL Server Installation Error 1639?

Last week, I was installing SQL Server 2012 on one of the database server. Unfortunately, the installation was failed with the error 1639. I have given below the details of this error code.

Product: Microsoft SQL Server Browser – Update Service Pack 1 for Microsoft SQL Server Browser (KB-NUMBER)’ could not be installed. Error code 1639.

SQL Server Installation Error 1639

Root Cause

I was not able to find any reason behind this error because I had followed all prerequisites before starting this installation. I went to some forums to get a root cause of this error 1639 or solution to fix it and what i found is described in this article.

This issue (Error 1639) comes when there is a blank space between your SQL Server setup folder directories. As I found my setup files were placed under a directory named “SQL Server 2012”. You can see there are two blank space between this directory name. This was the main reason or cause behind getting this SQL Server installation error. Read next section to fix this issue and install SQL Server successfully on your database server.

Resolution

To fix this issue, we have decided to first uninstall SQL Server instance that was failed to install. I have uninstalled it from “Add and Remove Programs” and deleted all SQL Server folders that was created during the installation. Once failed installation of SQL Server was uninstalled from database server, we have rebooted the machine to proceed with fresh installation.

As I mentioned above, issue was due to blank space between the parent directory of SQL Server setup files. You can see the name of directory in below screenshot.

blank space between folder names

Now I have removed the blank space between the words of this folder name and changed it to “SQLServer2012”. You can see the below screenshot of this change.

Remove blank space of folder name

That’s all to fix this issue. Now go ahead and start the installation again for your work.

Once this directory was renamed, I have started the SQL Server installation process. I had launched setup file and proceed for installation. You can also right click on setup file and choose “Run as Administrator” to start the installation. Follow all windows and processes of installation process as you did last time to install it. This time your SQL Server instance will be installed without any issue.

The key takeaway from this issue is to never keep any bank space between files or folders otherwise you will be end up with similar issues.

I hope you like this article. Please Like, Share, Comment & Subscribe to this website to get all new articles directly to your index. You can also follow our Facebook page and Twitter handle to get latest updates.

Read More:

 

Maruti Nandan

I am working at one of the top MNCs and have extensive experience on all versions of SQL Server since 2000,I have good hands on experience onfollowing database features: Database Mirroring, Always ON, Replication, Log Shipping, Geo-Clustering and Performance Tuning and delivered many SQL Server projects on consolidation, upgrades, heterogeneous replication, HA / DR solutions, automation and major performance tuning
Summary
Article Name
How to Fix SQL Server Installation Error 1639?
Description
Last week, I was installing SQL Server 2012 on one of the database server. Unfortunately, the installation was failed with the error 1639. I have given below the details of this error code. Product: Microsoft SQL Server Browser – Update Service Pack 1 for Microsoft SQL Server Browser (KB-NUMBER)’ could not be installed. Error code 1639.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *