troubleshooting Question

Windows 2008 r 2 sql server refuse tls 1.0 connexion

Avatar of cawasaki
cawasaki asked on
* tls/sslWindows OSWindows Server 2008Microsoft SQL ServerActive Directory
3 Comments1 Solution54 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
lcohan
Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros