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

 

 


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!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

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!

Essential SQL Server Development Tips for SQL Developers - Online Course
(Lifetime Access, Certificate of Completion, downloadable resources and more!)

Learn More


 

Featured Online Courses:

 

Read Also:

 

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Check our eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Loading...

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

© SQLNetHub