Link to home
Start Free TrialLog in
Avatar of rich55

asked on

odbc connection error

SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][TCP\IP Sockets]ConnectionOpen (SECCreateCredentials()).
Connection failed:
SQLState '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP\IP Sockets] SSL Security error

There is another entry that says the solution is a registry key, but doesn't give the key.  This conneciton is from a W2K3 Standard web server to a SQL 2005 db on a W2K3 server.  I have 2 other web servers with same config that work.  This error generates no sql logs.  The user id and pw have been verified to work on the sql server.
Avatar of Brad Howe
Brad Howe
Flag of Canada image

Hi There,
You are getting the SSL error, because every connection attempt to SQL Server 2005 is automatically encrypted.  

Check the following registry key on the client machine.

If the Encrypt value is set to 1, then the client is requesting SSL.
Change this to zero and try again.

As well, Is your current SSL certificate on the SQL Server in order with the proper HOSTNAME?

Avatar of rich55


What is the encrypt key supposed to look like?  The SuperSocketNetLIb key is there but with only a default value.
The value is a DWORD called "Encrypt" Set it to '0'
You could also just turn off "Force Enctpytion" if it is not required.

"When the ForceEncryption option for the Database Engine is set to No, encryption can be requested by the client application but is not required. SQL Server must be restarted after you change the ForceEncryption setting."
Avatar of rich55


I added the dword value and set it to 0, rebooted and got the same error.  I made that change on the web server, not the SQL server.  I don't have any control of the SQL server.  I'm pretty sure it's my web server with the problem.  I have 2 other W2K3 web edition servers with same config that are working fine.
Avatar of rich55

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial