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.
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 Sp2SQL Server 2005 Standard Edition SP3 Build 4266Issue: 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. |
|
|
|
|