Error installing SSMS : There is a problem with this Windows Installer package. A DLL required for this installation to complete could not be run. Error code: 1723

Mohamed Yousef 1 Reputation point
2022-08-15T22:40:01.64+00:00

Greetings,

Here's what i tried so far :

  • un register/re register MSI, Disable/Enable
  • Regedit, Under MSI.package adding a "runas" key
  • Deleteing "Temp" files and getting the file permissions.
  • Trying different versions of SSMS ( 2014, The latest, The one before the latest, SQL Express ) Same error.
  • Running windows update ( It's up to date now )
  • Running SSMS setup on command prompt
  • Running sfc/scannow

I've windows 10 Home 21H2

Here's the log file of my last failed setup ( SSMS 18.12.1 ) ( fatal error during installation 0x80070643 ) :

https://pastebin.com/Bd4nhCzf

Thank you.

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
6,711 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,131 questions

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 20,791 Reputation points Microsoft Vendor
    2022-08-16T03:07:49.02+00:00

    Hi @Mohamed Yousef ,

    I could not open the log file that you offered. Please try below steps again. Then run the SSMS setup as administrator.

    Unregister Windows Installer, and then reregister Windows Installer. To do this, follow these steps:

    1. On the "Start" menu, click "Run:.
    2. In the "Open" box, type "msiexec /unreg", and then press ENTER.
    3. On the "Start" menu, click "Run".
    4. In the "Open" box, type "msiexec /regserver", and then press ENTER.

    also:

    Click Start
    Type: CMD, from the results, right click CMD
    Click 'Run as Administrator'
    At the Command Prompt, type: sfc/scannow
    This will check for any integrity violations
    Restart your system

    -----------------------------------------------------------------------------------------------------------------------------------------------

    If the answer is helpful, please click ”Accept Answer” and kindly upvote it.

  2. Limitless Technology 37,611 Reputation points
    2022-08-16T14:34:48.6+00:00

    Hello there,

    From the error log, we can know that this error cause by failed to install MSI package. These problems may occur when the Windows Installer database file (.msi) or the Windows Installer patch file (.msp) is missing from the Windows Installer cache. The Windows Installer cache is located in the folder: %windir%\installer.

    The below thread discusses the same issue and you can try out some troubleshooting steps from this and see if that helps you to sort the Issue.

    https://learn.microsoft.com/en-us/answers/questions/289197/error-0x80070643-microsoft-sql-server-management-s.html

    ---------------------------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept it as an answer--

  3. CathyJi-MSFT 20,791 Reputation points Microsoft Vendor
    2022-08-17T07:17:35.727+00:00

    Hi @Mohamed Yousef ,

    I asked my colleague to help me opening the log link. I found some information from this log.

    > 2136.[2BF0:3D90][2022-08-15T23:07:55]e000: MainViewModel.OnPackageError: setup failed for packageId: sqlncli.msi, package: Microsoft SQL Server 2012 Native Client , errorCode: 1723, errorMessage: There is a problem with this Windows Installer package. A DLL required for this installation to complete could not be run. Contact your support personnel or package vendor

    Did you install Microsoft SQL Server 2012 Native Client on your server? You can check this from Control Panel\Programs\Programs and Features. If you have installed it, please uninstall it and run the SSMS setup as administrator again.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

  4. CathyJi-MSFT 20,791 Reputation points Microsoft Vendor
    2022-08-23T09:21:01.783+00:00

    Hi @Mohamed Yousef ,

    > This is not a server, this is my pc and i'm trying to install ssms.

    If you install SQL server on your PC, which OS that you using on your PC? Windows server? If so, please share us a screenshot about programs and features installed on your server? You can get this from Control Panel.

    > Here's another log file for sql express this time, if it makes anything clearer, https://pastebin.com/yrm2R9Bz

    MSI (s) (FC:0C) [06:39:10:429]: Product: Microsoft SQL Server 2012 Native Client -- Error 1723. There is a problem with this Windows Installer package. A DLL required for this installation to complete could not be run. Contact your support personnel or package vendor. Action SNAC_SetClientSSNLDefaults_32, entry: SNAC_SetClientSSNLDefaults, library: C:\Windows\Installer\MSI9F77.tmp
    2350.MSI (s) (FC:0C) [06:39:11:389]: Product: Microsoft SQL Server 2012 Native Client -- Installation failed.

    After reading your log file, still suggest you check if you have installed Microsoft SQL Server 2012 Native Client on your PC.

    Have you logged in as admin on the pc? Did you run SSMS setup file as administrator?

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

  5. Aaron Christenson 41 Reputation points
    2023-03-28T13:18:50.1366667+00:00

    I had this problem with adding a new node to an existing cluster. I found that Dot Net 3.5 feature was not installed on the Windows 2019 server. Once I added that and restarted, I was able to install SQL Server 2017 as an additional node.