SQL2005 connection problems from ASP

Hi -

I'm having an issue on Windows Server 2003 when using ASP to launch a
process that connects to SQL2005 using SQL Authentication. Basically in
this setup no matter what I do in this setup the connection will always
fail with the error: "SSL Security error ConnectionOpen
(SECDoClientHandshake())."

I am certain that the connection string we are using is valid based on
the fact it works on any other platform with the same setup (in fact it
even works on Windows 2003 server against SQL2000).

I've tried playing with the Identity property of the Application Pool
that the virtual directory is running under and I can make this work if
I change the App Pool identify to Local System. However changing it to
anything else, including an Adminstrator account, still causes this to
fail.

I've done some searches and I've seen some articles related to this
error which mention SSL certificates causing issues with SQL Server
however I have never installed any certificates on the server and have
not enabled encryption in SQL2005.

Any advice here? Can anyone else get IIS6 on Win2k3 to make a SQL2005
connection using SQL Authentication? If so I'd be interested in knowing
how!





*** Sent via Developersdex http://www.developersdex.com ***