April 9, 2018 at 3:45 pm
Hi,
has anyone encountered this error when trying to connect from a SQL Server 2014 instance to a SQL Server 2008 instance?:
'A connection was successfully established with the server, but hen an error occurred during the login process. (Provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.) (Microsoft SQL Server)
The client and server cannot communicate, because they do not possess a common algorithm'
Any help will be appreciated...
April 9, 2018 at 3:55 pm
Do you have tls1.0 disabled?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2018 at 4:03 pm
On the client or server side? Let me verify...
April 9, 2018 at 4:51 pm
Yes. TLS 1.0 is disabled for both client and server.
April 10, 2018 at 3:31 am
EMtwo - Monday, April 9, 2018 4:51 PMYes. TLS 1.0 is disabled for both client and server.
What `are the exact versions of the 2 instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2018 at 7:55 am
Microsoft SQL Server 2014 64-bit Standard Edition and Microsoft SQL Server 2008 R2 SP1 64-bit Enterprise Edition.
April 10, 2018 at 11:29 am
So, after doing some research, a suggested solution is to enable TLS 1.0 in the registry??? Would you recommend this? Your advice is appreciated. Thanks.
April 11, 2018 at 9:22 am
Hello:
So, enabling the TLS 1.0 in the registry on the SQL Server 2014 Server solved my problem.
Thanks for your attempt to help me solve my issue, Perry Whittle.
April 11, 2018 at 9:57 am
EMtwo - Tuesday, April 10, 2018 7:55 AMMicrosoft SQL Server 2014 64-bit Standard Edition and Microsoft SQL Server 2008 R2 SP1 64-bit Enterprise Edition.
What are the exact version?
use the following query against each instance
SELECT @@version
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2018 at 9:58 am
EMtwo - Wednesday, April 11, 2018 9:22 AMHello:
So, enabling the TLS 1.0 in the registry on the SQL Server 2014 Server solved my problem.Thanks for your attempt to help me solve my issue, Perry Whittle.
Don't do this yet!
Provide the sql server versions you are using
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2018 at 11:08 am
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64)
Jun 11 2012 16:41:53
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) Jun 11 2012 16:41:53 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
April 11, 2018 at 1:06 pm
EMtwo - Wednesday, April 11, 2018 11:08 AMMicrosoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64)
Jun 11 2012 16:41:53
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) Jun 11 2012 16:41:53 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
What version is the 2014 instance?
in order to support TLS 1.2 you need to apply the following patches in the following link to sql server 2008 R2
https://support.microsoft.com/en-gb/help/3135244/tls-1-2-support-for-microsoft-sql-server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2018 at 1:25 pm
My bad, here it is:
Microsoft SQL Server 2014 - 12.0.4100.1 (X64)
Apr 20 2015 17:29:27
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
April 11, 2018 at 1:34 pm
EMtwo - Wednesday, April 11, 2018 1:25 PMMy bad, here it is:
Microsoft SQL Server 2014 - 12.0.4100.1 (X64)
Apr 20 2015 17:29:27
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
ok so check the link i posted
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2018 at 8:36 am
Thank you.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply