Error during pre-login handshake: SSL certificates

  • Dear Friends

    I face an issue during login to SSMS :

    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.) (.Net SqlClient Data Provider)

    I read some posts they provide solution to delete personal certificate using MMC console , I did it but still the issue there.

    Environment :

    SQL SERVER 2005

    Windows 2003

    For your help and support

    Regards,

    Nasser

  • Dear Friends

    Any help will be appreciated.

    Regards,

    Nasser

  • not had the issue before but a quick google came up with a few results,

    one solution might be this

    Have you enabled System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing policy in the following location: Computer Configuration\Windows Settings\Security Settings\Local Policies\Security Options\ on any of the systems?

  • Thanks for your reply i have check it it's disabled

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply