Microsoft – SQL Server – Connectivity – Error – SSL Provider: The Local Security Authority cannot be contacted (HResult 0x80090304, Level 16, State 1)

Background

From this one host,  Connecting to any MS SQL Server Instance on the Network came back with this error:

 

Error Message

HResult 0x80090304, Level 16, State 1
SSL Provider: The Local Security Authority cannot be contacted

TroubleShooting

Tried with the following NCipher \ SSL Configuration Changes:

  1. Check the version and date modified for the file dbnetlib.dll located under c:\windows\system32 in your client . If the date modified is not the same then replace the file with the one from working box.
  2. Since you are using nCipher, change the following registry key: HKLM\Software\nCipher\Cryptography\UseModulekeys to 0 and reboot, change it back to 1 and reboot and see if that helps.
  3. I can see a number of cases where the issue occur when nCipher is the default CSP. Set SQL Server as the default CSP for the SQL Servers.
  4. If the below key is enabled, disable it. This is only for SQL 2008 (which support nCipher)  so for other SQL server we need to disable it
    [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\Schannel\Protocols\TLS 1.0\Server]
    “Enabled”=hex:00,00

Resolution

But, nothing quite helped until we un-installed the NCipher\nFast Client.

We went this route as we were no longer using NCipher\nFast on that box.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s