Posted by pigeon on 06/06/05 13:39

Hello, I just finished installing MS SQL 2000 (w/ latest SP) on a
brand spankin new w2k3 server.

I am having a wierd issue though.

I installed a certificate for the server (using the right DN)... I
used www.godaddy.com to get the cert.

but my issue is, we need all communication to be encrypted.
So I enabled "force protocol encryption" through "sql server
network utility" on the db server.

Now users can login and have all there transmission encrypted.. This
works fine.. but what doesn�t work is when the client computer checks
"Use strong data encryption� when making an ODBC.

If a user does that.. (using a network sniffer, I see 8x duplicate
traffic... maybe more.. but basically around 110packets), the user
gets:
----
Microsoft SQL Server ODBC Driver Version 03.85.1117

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security error
Disconnecting from server

TESTS FAILED!
---
and the above is outputted after ~20seconds of the program stalling
that is trying to make an ODBC.

thanks for any help!

Lee

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Discussions-SSL-Security-Error-ftopict228829.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=791250

• Next in forum: best backup software for MS SQL?
• Prev in forum: Re: Another Newbie Question (about queries)
• Thread view: SSL Security Error

[Reply to this message]