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.
[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.
ASKER
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.
http://msdn.microsoft.com/en-us/library/ms189067.aspx
"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."
http://msdn.microsoft.com/en-us/library/ms189067.aspx
"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."
ASKER
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.
registry-shot..jpg
registry-shot..jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
HKEY_LOCAL_MACHINE\SOFTWAR
If the Encrypt value is set to 1, then the client is requesting SSL.
http://support.microsoft.com/?id=322144
Change this to zero and try again.
As well, Is your current SSL certificate on the SQL Server in order with the proper HOSTNAME?
Cheers,
Hades666