SQL Server and SSL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jaylou - 25 Jan 2007 17:26 GMT

Hi All,
I just moved my databases from an older Server to a new windows 2003 SP1
server. I was connected and all my jobs ran fine last night. All of a
sudden this morning I tried to connect thru EM and I get the following error:
"A connection Could not be established to (local)
Reason: SSL Security Error
ConnectionOpen(SecDoClientHandShake())..
Please verify SQL Server is running and check your reg....."

Has anyone seen this before? Since when is SQL looking for SSL's????

TIA,
Joe

Reply to this Message

Steve - 28 Jan 2007 01:25 GMT

> Hi All,
> I just moved my databases from an older Server to a new windows 2003 SP1
[quoted text clipped - 9 lines]
> TIA,
> Joe

googling "sql server" "SSL Security Error
ConnectionOpen(SecDoClientHandShake())"
returns a variety of explanations.

Reply to this Message

Antonio Soto - 29 Jan 2007 09:06 GMT

Hi jaylou,

Did you install any certificate in your server?? Take a look on this
http://support.microsoft.com/kb/309398/en-us

Hope this helps!!

Signature

Antonio Soto
Solid Quality Learning
http://www.sqlu.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference

> Hi All,
> I just moved my databases from an older Server to a new windows 2003 SP1
[quoted text clipped - 10 lines]
> TIA,
> Joe

Reply to this Message

jaylou - 29 Jan 2007 13:55 GMT

Thanks both.

I have seen these and delted all my certificates on the server. Since I
never seen this before I was just wondering if anyone esle has and if there
were any explainations about this.

Thanks again for your responses.

Joe

> Hi All,
> I just moved my databases from an older Server to a new windows 2003 SP1
[quoted text clipped - 9 lines]
> TIA,
> Joe

Reply to this Message