Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
Error says that the algorithm which both servers are using for pre-login handshake is not matching. How do we know which algorithm servers are using? –  Jigar Mar 12 '13 at 4:48
add comment

1 Answer

Finally after so many days, it got solved:) As the error says that server and client does not possess a common algorithm, I checked all the SSL algorithm parameters and finally found some difference in Sharepoint server and DB server. Removed this difference and things started working.

To check for these parameters go to registry (regedit) HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL Check all the values underneath this Key. For me, it was Hashes Key which was different in Sharepoint Server. Changed that to make it same as DB server and they started communicating.

SCHANNEL is Microsoft implementation of SSL.

Hope this helps others in saving time.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.