Error during pre-login handshake: SSL certificates

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Error during pre-login handshake: SSL...

Error during pre-login handshake: SSL certificates

Rate Topic

Display Mode

Topic Options

Author

Message

nalessa

Posted Monday, March 26, 2012 6:42 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, January 28, 2013 5:43 AM
Points: 17, Visits: 124

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

Post #1272605

nalessa

Posted Tuesday, March 27, 2012 1:57 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, January 28, 2013 5:43 AM
Points: 17, Visits: 124

Dear Friends

Any help will be appreciated.

Regards,
Nasser

Post #1273260

anthony.green

Posted Tuesday, March 27, 2012 2:02 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1273264

nalessa

Posted Tuesday, March 27, 2012 3:00 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, January 28, 2013 5:43 AM
Points: 17, Visits: 124

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

Post #1273299

« Prev Topic | Next Topic »

Permissions