Environment: Application Servers: Window 2003 standard, Sp2 (64 bit), Not in Domain .Net version Installed: .Net Framework 3.5Sp1, .Net Framework 3.0, .Net Framework 2.0 Sp2
SQL Server 2005 Standard Edition SP3 Build 4266
Issue: Our web application based on .Net framework 2.0 is receiving the below error in event log while connecting to SQL 2005 instance. We are using the SQLOLE DB Provider to make the connection. In he connection string we pass following information.
1. Server IP
2. Database Name
3. User Id
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The Local Security Authority cannot be contacted.
Temporary work around:
We are able to temporarily fix this issue by encrypting and decrypting web.config file.
Also we only encrypt app setting part of web config file with ASP.net default "DataProtectionConfigurationProvider".
The following code is used in the application for establishing the connect
View Complete Post