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 |
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
 Posted - 2011-03-14 : 16:20:23
|
| I am having an issue with a SQL Server 2005 server and we are getting this error:"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.) (Microsoft SQL Server, Error: -2146893007)".We checked the microsoft kb on this and we don't have encryption policy setup, but then I was reading on another foruma bout this so-called 'Force protocol encryption' option we can turn off in SQL Server configuration manager, but I am having trouble finding it. Does anyone know how I would even check if I have it on, step-by-step?The main issue is we having difficulty connecting a sql server 2005 and sql server 2008 on two separate domains. We had it working before and, somehow, something happened and now they don't want to talk to each other. So, this SSL error is what's happening. Anyone who can point me in the right direction will get a virtual cookie.Thank you. |
|
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
Posted - 2011-03-15 : 10:03:12
|
| Just in case anyone looks at this future reference, it turns out the issue was independent of SQL. It was some low-level cypher that was installed that was affecting Windows, an external program. |
 |
|
|
|
|
|
how to turn off 'Force protocol encryption'?