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

Question

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.

Answer 1

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.

Answer 2

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--

Answer 3

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".

Answer 4

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".

Answer 5

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.