June 25, 2018 at 3:13 am
I am unable to connect to a database server running :
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
from SSMS 2016 and getting following error:
A connection was successfully established with the server, but then 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.)
I tried to check failed login (configured on server to log failed logins), there is nothing appearing in log.
I checked ports and checked telnet to see if ports are blocked, SQL server configuration tool, for TCP etc. everything is OK, this database server is connected to other clients without any issue, I just tried with SSMS 2016 and getting error. The login I tried with SQL and windows both having same error. Kindly help to solve this issue.
Regards,
Shamshad Ali
June 25, 2018 at 3:21 am
Hi,
check you TLS Setting on the client and the sql server.
This could the reason for the error.
Kind regards,
Andreas
June 25, 2018 at 3:23 am
Your issue is TLS related, not so much version or login specific, review all the known issues and fixes with TLS connections here.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 25, 2018 at 3:29 am
how to check TLS settings on client and server ?
June 25, 2018 at 3:34 am
On client and server both have following ;
Force Protocol Encryption - OFF
Trust Server Certificate - OFF
June 25, 2018 at 3:42 am
Do I need to run any update on the database server running SQL Server 2008 R2?
You will need to apply the necessary client component fixes on the server that hosts the SQL Server instance (eg. MS ODBC Driver, SQL Server Native Client) to ensure that the client components installed on the server also support TLS 1.2.
Installing any update is not allowed on db server running 2008 R2 because it is 3rd party configured and we only want to setup connecting this server for reporting (service using 2016 version) purpose. Is there any workaround for this?
I also see following link
This hotfix enables Transport Layer Security (TLS) 1.1/1.2 for SQL Server connectivity in System.Data.dll.
This is risky and can't do becase several third party applications are using database running on this DB servrer.
Please help.
June 25, 2018 at 12:30 pm
shamshad.ali - Monday, June 25, 2018 3:42 AMDo I need to run any update on the database server running SQL Server 2008 R2?You will need to apply the necessary client component fixes on the server that hosts the SQL Server instance (eg. MS ODBC Driver, SQL Server Native Client) to ensure that the client components installed on the server also support TLS 1.2.
Installing any update is not allowed on db server running 2008 R2 because it is 3rd party configured and we only want to setup connecting this server for reporting (service using 2016 version) purpose. Is there any workaround for this?
I also see following linkThis hotfix enables Transport Layer Security (TLS) 1.1/1.2 for SQL Server connectivity in System.Data.dll.
This is risky and can't do becase several third party applications are using database running on this DB servrer.
Please help.
If no changes are allowed due to it being a vendor's system, you should contact that vendor.
Sue
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply