Search code examples
sqlsql-servervisual-studiovisual-c++ssms

Unable to install Microsoft SQL Server Management Studio because of error 0x80070643

I am trying to install SSMS but the error 0x80070643 keeps appearing. It says that I do not have Visual Studio C++ 2017 installed, but the SSMS installer does in fact install Visual Studio C++ 2017. So I don't know why it does not find it.

Here is the part of the installation log where the error seems to appear

                      [1130:03E4][2019-10-11T19:15:27]i323: Registering package dependency provider: 
                      {72AFAF21-33FB-45A5-9468-A9EC07427F82}, version: 17.4.1.1, package: 
                       msodbcsql.msi
                       [168C:1B4C][2019-10-11T19:15:27]i000: MainViewModel.OnPackageAction: Install 
                       Started for package Microsoft ODBC Driver 17 for SQL Server
                       [1130:03E4][2019-10-11T19:15:27]i301: Applying execute package: 
                       msodbcsql.msi, action: Install, path: C:\ProgramData\Package Cache\{72AFAF21- 
                          33FB-45A5-9468-A9EC07427F82}v17.4.1.1\x64\msodbcsql.msi, arguments: ' 
                          MSIFASTINSTALL="7" AddLocal="SQL_SQLODBC_CORE" 
                           IACCEPTMSODBCSQLLICENSETERMS="YES"'
                          [168C:1B4C][2019-10-11T19:15:27]i000: 
                            MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall 
                            progress: 0
                           [168C:1B4C][2019-10-11T19:15:27]e000: 
                              BootstrapperEngineDataModel.OnError: Burn engine encountered error. 
                           PackageId: msodbcsql.msi, ErrorType: WindowsInstaller, ErrorCode: 1723, 
                             Data: 
                         1723,IsPendingRebootKey,IsPendingReboot,C:\WINDOWS\Installer\MSI37D2.tmp, 
                           ErrorMessage: Please install the Visual C++ 2017 Redistributable from 
                            https://aka.ms/vs/15/release/vc_redist.x64.exe before running this 
                       installer. , UIHint: 0

What can I do to fix it? Already tried to uninstall and install Visual Studio C++ 2017 but it does not work

I installed VS C++ 2017 via the link the error gives me, then restarted the computer, but it still isn't working. Tried to erase it myself and then let the SSMS installer do it for me, but then again, does not work.

I also tried to install the ODBC driver myself, but the same error occurs.

However, with VS C++ 2013 (which is also installed by the SMMS) the error does not occur, as I installed the ODBC 2013 driver and it worked perfectly

As you can see, VS is installed by the SSMS installer. Curiously, when I download VS c++2017 from the link given by the error it allows me to install it even though it should not because it is already installed

Solution

  • Okay, the problem was fixed and now I have succesfully installed the ODBC Driver 17.

    I had deactivated the antivirus in my computer, downloaded VS C++ 2017 again and then proceeded to install the driver and it finally worked.

    This is the only solution that I could find, as other pages did not have a specific answer for it. If you have the same problem, consider doing this and see if the answer is fixed

    Thanks to everyone who helped me.