Can't Connect Data Source in ODBC to SQL 2005 Server -- "SSL Security Error"
Posted on 2007-04-11
I have two servers, clustered, mirror images of each other, running Windows 2003 Server, IIS 6.0.
I have a DNS connection setup on BOTH servers going to a SQL 2000 / Win 2000 Server machine that needs to change and point to an entirely new database on a SQL 2005/Win 2003 Server.
Here is my problem:
Server A connects to the new server just fine, no problems whatsoever.
Server B gives me an error message after I change the servername, and enter in my username\pwd while setting up the DNS. The error reads:
[Microsoft][ODBC SQL Server Driver][TCP\IP Sockets]ConnectionOpen (SECCreateCredentials()).
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP\IP Sockets] SSL Security error
There are no error messages in the log files on computer manager or IIS.
Nothing is being written to the trace log file when I enable tracing in the Client Network Utility.
There are no SSL certs installed on either server.
The port number is correct.
All 4 servers involved are in the same domain.
I'm using the correct username/password and it has been verified that the SQL Server permissions are setup correctly (and confirmed b/c Server A can connect and run fine).
I can open a command prompt and telnet to the SQL Server as well as ping it from my IIS web server.
Any suggestions / recommendations are appreciated!
It seems the problem has to be on the Web Server side since Server A is connecting OK, I just don't know where to look next.