locked
Cannot connect to SQL Server 2008 R2 from Sharepoint server RRS feed

  • Question

  • 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.

    Thursday, March 7, 2013 10:18 AM

Answers

  • Hi all,

    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.

    Wednesday, March 13, 2013 6:00 AM

All replies

  • Refer Link, it may help :http://www.softwaremaniacs.net/2010/08/sql-server-2005-and-selfssl.html

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Thursday, March 7, 2013 11:59 AM
  • Hi Rohit,

    I went through the link and found that there are no certificates visible in Personal Store in mmc console on db server. It is empty. But there was a certificate in Sharepoint Server under Personal Store. I deleted that but still getting same error.

    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?

    Friday, March 8, 2013 4:26 AM
  • Hi all,

    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.

    Wednesday, March 13, 2013 6:00 AM