Unable to load DLL ‘Microsoft.Data.SqlClient.SNI.x86.dll’ – Error Launching SSMS 19

Hi friends, in this short article, we will be discussing about, how you can resolve the following issue that might occur under certain circumstances, when launching SQL Server Management Studio (SSMS) 19.x: Unable to load DLL ‘Microsoft.Data.SqlClient.SNI.x86.dll’

 

The Error Message

The exact error message is the below:

 

Cannot connect to [instance name]

——————————
ADDITIONAL INFORMATION:

Unable to load DLL ‘Microsoft.Data.SqlClient.SNI.x86.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E) (Microsoft.Data.SqlClient)

 

Possible Root Cause

The most likely root cause for the above error, is that you had previously installed SSMS 19 preview and you installed the newer version without first removing the preview version.

 

Resolution

To resolve the issue, you can try the following actions:

• Completely uninstall SSMS 19
  • Prior to that, make a backup of any user preferences
• Reboot the computer
• Install again the latest release of SSMS 19
  • The latest release can found in the official page

 

 

---

Strengthen your SQL Server Administration Skills – Enroll to our Online Course!

Check our online course on Udemy titled “Essential SQL Server Administration Tips”
(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Learn More

 

---

 

Learn essential SQL Server development tips! Enroll to our Online Course!

Check our online course titled “Essential SQL Server Development Tips for SQL Developers”
(special limited-time discount included in link).

Sharpen your SQL Server database programming skills via a large set of tips on T-SQL and database development techniques. The course, among other, features over than 30 live demonstrations!

Learn More

---

 

Featured Online Courses:

• SQL Server 2022: What’s New – New and Enhanced Features
• Introduction to Azure Database for MySQL
• Working with Python on Windows and SQL Server Databases
• Boost SQL Server Database Performance with In-Memory OLTP
• Introduction to Azure SQL Database for Beginners
• Essential SQL Server Administration Tips
• SQL Server Fundamentals – SQL Database for Beginners
• Essential SQL Server Development Tips for SQL Developers
• Introduction to Computer Programming for Beginners
• .NET Programming for Beginners – Windows Forms with C#
• SQL Server 2019: What’s New – New and Enhanced Features
• Entity Framework: Getting Started – Complete Beginners Guide
• A Guide on How to Start and Monetize a Successful Blog
• Data Management for Beginners – Main Principles

 

Read Also:

• Useful Python Programming Tips
• SQL Server 2022: What’s New – New and Enhanced Features (Course Preview)
• How to Connect to SQL Server Databases from a Python Program
• Working with Python on Windows and SQL Server Databases (Course Preview)
• The multi-part identifier … could not be bound
• Where are temporary tables stored in SQL Server?
• How to Patch a SQL Server Failover Cluster
• Operating System Error 170 (Requested Resource is in use)
• Installing SQL Server 2016 on Windows Server 2012 R2: Rule KB2919355 failed
• The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group
• A connection was successfully established with the server, but then an error occurred during the login process.
• SQL Server 2008 R2 Service Pack Installation Fails – Element not found. (Exception from HRESULT: 0x80070490)
• There is insufficient system memory in resource pool ‘internal’ to run this query.
• Argument data type ntext is invalid for argument …
• Fix: VS Shell Installation has Failed with Exit Code 1638
• Essential SQL Server Development Tips for SQL Developers
• Introduction to Azure Database for MySQL (Course Preview)
• [Resolved] Operand type clash: int is incompatible with uniqueidentifier
• The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered – How to Resolve it
• SQL Server replication requires the actual server name to make a connection to the server – How to Resolve it
• Issue Adding Node to a SQL Server Failover Cluster – Greyed Out Service Account – How to Resolve
• Data Management for Beginners – Main Principles (Course Preview)
• Resolve SQL Server CTE Error – Incorrect syntax near ‘)’.
• SQL Server is Terminating Because of Fatal Exception 80000003 – How to Troubleshoot
• An existing History Table cannot be specified with LEDGER=ON – How to Resolve
• Rule “Setup account privileges” failed – How to Resolve
• SQL Server Error 262: CREATE DATABASE permission denied in database – How to Resolve
• … more SQL Server troubleshooting articles

 

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Check our eBooks!

 

Rate this article: (1 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub