Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Local Security Authority cannot be contacted

Author  Topic 

agiotti
Starting Member

37 Posts

Posted - 2010-09-27 : 19:15:06
I am a SQL Server DBA and trying to assist our .Net developers. Any advise is extremely appreciated.

Environment: Application Servers: Window 2003 standard, Sp2 (64 bit), Not in a 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 the connection string we pass following information.
1. Server IP
2. Database Name
3. User Id
4. Password

Error message:
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 decrypting and encrypting the web.config file manually. Note: We only encrypt app setting part of web config file with ASP.net using the standard default DataProtectionConfigurationProvider.
   

- Advertisement -