From this one host, Connecting to any MS SQL Server Instance on the Network came back with this error:
HResult 0x80090304, Level 16, State 1 SSL Provider: The Local Security Authority cannot be contacted
Tried with the following NCipher \ SSL Configuration Changes:
- 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.
- 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.
- 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.
- 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
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.