vs shell installation has failed with exit code 1638

sql-server windows-server-2012-r2
Hiren Parghi picture Hiren Parghi · May 25, 2018 · Viewed 10.8k times · Source

I have received the following error while installing MSSQL 2017 on Windows 2012 R2.

vs shell installation has failed with exit code 1638

enter image description here

Answer

Husam Ebish picture Husam Ebish · Aug 7, 2018

You must install SQL Server first before installing Visual Studio 2017.

If you have already installed Visual Studio 2017, do not worry, just follow the steps below:

Uninstall the Microsoft Visual C++ 2017 Redistributable (x86) and (x64)

enter image description here

Then install SQL Server.

Do not forget to select "Database Engine Services"

enter image description here

Change "Startup Type" of SQL Server Browser from "Disabled" to "Automatic"

enter image description here

The installation will be done without any problems:

enter image description here

Then reinstall the Microsoft Visual C++ 2017 Redistributable (x86) and (x64)

Related questions

How to solve Microsoft SQL Server. Error 233. Provider: SSL Provider

After the global RansomeWare attack, we updated our Windows Server 2012 R2 only to find out that our SQL Server Management Studio (SSMS) stopped working. Whenever we try to connect to SSMS locally or remotely it provides us the following Error: …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More