Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll'

Ocelot013 1

I have two published environment, Staging and one for live. my published project works in test env. without any issue, but as soon as I deploy it on live env.
I also should mention that Microsoft.Data.SqlClient.SNI.x64.dll exists in \bin after deployment.

I get the following error:

ERROR 2021-06-08 16:45:34,415 455867ms ysomeController MoveNext           - System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.SNILoadHandle' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
   at Microsoft.Data.SqlClient.SNINativeManagedWrapperX64.SNIInitialize(IntPtr pmo)
   at Microsoft.Data.SqlClient.SNILoadHandle..ctor() in H:...\Microsoft\Data\SqlClient\TdsParserSafeHandles.cs:line 19
   at Microsoft.Data.SqlClient.SNILoadHandle..cctor() in H:...\Microsoft\Data\SqlClient\TdsParserSafeHandles.cs:line 17
   --- End of inner exception stack trace ---
   at Microsoft.Data.SqlClient.TdsParser..cctor() in H:...\Microsoft\Data\SqlClient\TdsParser.cs:line 177
   --- End of inner exception stack trace ---
   at Microsoft.Data.SqlClient.TdsParser..ctor(Boolean MARS, Boolean fAsynchronous) in H:...\Microsoft\Data\SqlClient\TdsParser.cs:line 38
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) in H:...\Microsoft\Data\SqlClient\SqlInternalConnectionTds.cs:line 1831
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) in

Xingyu Zhao-MSFT 5,381 Reputation points

2021-06-15T02:36:58.327+00:00
Hi @VahidCheshmy-2526 ,
Take a look at the following two references:

Unable to load native SNI (Server Name Indication) library

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x86.dll'

Hope them could be helpful.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

17 answers

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
6 deleted comments

Comments have been turned off. Learn more
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
1 deleted comment

Comments have been turned off. Learn more
Srishti Purohit 0 Reputation points Microsoft Employee

2023-02-20T14:26:01.99+00:00

I am also facing the same issue. I tried installing sql management 19.1.0 but it dint help and i need to revert to 18.2 version.
I am stuck for very long now , please help
Please sign in to rate this answer.
Raghava Sai Akula 406 Reputation points

2023-04-04T13:45:58.73+00:00

I am using Azure Sql Database in my case

Raghava Sai Akula 406 Reputation points

2023-04-13T13:54:01.7533333+00:00

In my case , I am using AzureSql Database ,so there is no point of me installing SSMS on my Azure VM where Application is hosted in IIS. Could someone suggest a workaround?

Tarun Sharma 0 Reputation points

2023-05-01T09:47:39.3233333+00:00

Please refer my comments. Go for Repair instead uninstallation.

Raghava Sai Akula 406 Reputation points

2023-05-01T14:10:01.2866667+00:00

Could you elaborate, I quite couldn't get what to repair!

Marty Scherr 0 Reputation points

2023-06-08T13:31:48.4866667+00:00

I'm late to the party on this one. But here's how I fixed this issue. I used File Explorer and searched for file: Microsoft.Data.SqlClient.SNI.x86.dll. I found the file in the folder: C:\Program Files\WindowsPowerShell\Modules\dbatools\1.1.81\bin\smo.

It's part of the dbatools PowerShell Module install apparently. If you haven't used dbatools I strongly encourage you to do so. Plus you get the added bonus of getting this dll file that SSMS v19 is looking for.

So I copied this file to the SSMS v19 folder: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE

I was able to open SSMS v19 and it now connects just fine.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Tarun Sharma 0 Reputation points

2023-05-01T09:45:52.1533333+00:00

You could try with Repair option instead of uninstallation of SSMS.

For this try to uninstall from Control Panel>Programs and features. You will see option as Repair.

Just do a Repair, it worked for me.
Please sign in to rate this answer.
Ocelot013 1 Reputation point

2023-05-01T14:13:15.4033333+00:00

For me it was a permission issue in server, after granting the permissions it’s solved.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll'

17 answers

Your answer