Avatar of cawasaki
cawasaki
 asked on

Windows 2008 r 2 sql server refuse tls 1.0 connexion

hello,

i have sql 2008 server on windows 2008 R2;

HAVE a windows 2003 server with an application connect to a database on the sql server.

after a maintenance on our datacenter and shut down all server, the application on windows 2003 server cannot conenct anymore on sql server.

on windows 2008 R2 server, i have this error:

system log
event id 36874
source Schannel
An TLS 1.0 connection request was received from a remote client application, but none of the cipher suites supported by the client application are supported by the server. The SSL connection request has failed.

i understand that my windows server refuse tls1.0 conenxion?? so i have look on registry and see only SSL 2.0 entry on :

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols

so i have add tls 1.0 key, client and server and add this dword:
"DisabledByDefault"=dword:00000001

reboot the server and still connexion refused:

thanks for help
* tls/sslWindows OSWindows Server 2008Microsoft SQL ServerActive Directory

Avatar of undefined
Last Comment
lcohan

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
lcohan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
cawasaki

ASKER
the problem is that the windows 2003 server can connect to windows 2008 R2 server with sql 2008 for many years, and suddently after reboot all it stop working. so i am sure we can deal with cipher or tls regkey on windows 2008 R2 server to accept tl1.0
lcohan

Sorry it wasn't clear enough that that's the point I was trying to make - I think that can no longer be done and you will have to try implement/use the TLS 1.2 as noted at link I posted above.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy