Unable to Install Microsoft SQL Server 2014

Isaac Lynn 96 Reputation points
2021-07-01T19:45:04.067+00:00

I am unable to install Microsoft SQL Server 2014 on my machine. The detail.txt returns an error code 1639, and I think it is due to issues with the registry but I am unsure how to fix it or how to find those problematic registry keys.

I have tried repairing through SQL Server setup GUI, deleting the obvious registry folders (i.e. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server), installing 2008, nothing has worked.

After the install fails, I can see Microsoft SQL Server 2014 in my programs list but it fails to uninstall, so I believe it has just not been correctly cleaned up, but Microsoft program install and uninstall troubleshooter fails to find any issues with the registry.

Any help is appreciated.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
{count} votes

Accepted answer
  1. Isaac Lynn 96 Reputation points
    2021-07-02T19:57:03.087+00:00

    I finally found a solution. I went into the registry and turned on TLS 1.0, and turned off TLS 1.2 according to this article:
    https://blog.sqlauthority.com/2019/11/11/sql-server-error-17182-unable-to-initialize-ssl-support-the-client-and-server-cannot-communicate-because-they-do-not-possess-a-common-algorithm/

    I then turned uninstalled sql server 2014 and restarted my computer, then reinstalled 2014. After that I was able to turn my database server on in the services and get it running. I then went back into the registry and turned TLS 1.2 back on.

    For anyone who that doesn't work for, I think this article may be of use if the 17204 error persists:
    https://www.seesharpsoftware.com.au/sql-server-service-startup-failure/


1 additional answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,601 Reputation points
    2021-07-02T01:59:59.347+00:00

    Hi,

    It seems that you have tried to install SQL Server 2014 and 2008 on this computer many times.
    Do you specify the same name every time you install SQL Server (or always install it as a default instance). Try to install with a different name as a named instance.

    Error 1639 sometimes does indicate a problem with the registry key. But this usually requires further diagnosis based on the log file. Error 1639 in the log file(Summary.txt) usually points to another Component log file.

    If there is no SQL Server instance used/needed on this computer, considering the residual problems of the installation, it is recommended to perform a manual SQL Server installation cleanup on the entire computer, including directories and registry keys, and then retry the installation.
    http://www.sqlcoffee.com/Tips0026.htm