I have installed SQL Server 2008 R2 on dbserver and Sharepoint 2010 on webserver. When trying to configure Sharepoint to use the database installed on dbserver, it says it cannot connect. Then I installed SSMS on Sharepoint server and tried to connect to the Database Engine on dbserver but it throwed following 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)"
Surprisingly, I am able to connect to Analysis Services installed on dbserver from Sharepoint server. And am also able to connect to dbserver from third server. We don't need SSL enabled on any server.
Please help. Searched net and tried many options but in vain.