Solved

Can't Connect Data Source in ODBC to SQL 2005 Server -- "SSL Security Error"

Posted on 2007-04-11
8
3,155 Views
Last Modified: 2016-10-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:

Connection failed:
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 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.
0
Comment
Question by:LuckyDuck5281
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 4

Expert Comment

by:antonbijl
ID: 18893401
Seems strange since you've got it working on the one server...

A few questions:
1. Do you have client tools (2005 management studio or 2000 query analyser) installed on Server A? If so, can you connect to the SQL server using this (of course using the same credentials you're using in the connection setup)?
2. "I have a DNS connection setup", I'm guessing you mean DSN not DNS can you confirm? Do you use a specific tool for doing this setup or just the std MS ODBC data source administrator?
3. Since you refer to the username/password I assume you're using SQL mode authentication, please confirm.
4. Are the two connections connecting to the same database on the server and are you using the same username/pwd on both?
0
 
LVL 4

Expert Comment

by:antonbijl
ID: 18893766
Sorry, on seeing that again, question 1 should be: o you have client tools (2005 management studio or 2000 query analyser) installed on Server B? If so, can you connect to the SQL server using this (of course using the same credentials you're using in the connection setup)?
0
 
LVL 1

Author Comment

by:LuckyDuck5281
ID: 18894481

1. No, I do not have these tools installed.
2. I do mean DSN, sorry about that... I was typing too fast apparently  I am using the std MS ODBC Data source administrator
3. Yes, SQL mode authentication is used.
4. Yes, each Web Server is trying to go after the same Database.  This has never been an issue in the past or in other clustered web environments that we have set up the same/similar.  The same username/pwd is being used each time.

Thanks!
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 35

Expert Comment

by:David Todd
ID: 18894489
Hi,

If using DSN, and you using user or system DSN?

In other words, duplicate DSN's can exist - one in system, another in user, etc.

Make sure that there isn't a DSN of the same name that is still pointing to the old system - in one of the other DSN categories.

Regards
  David
0
 
LVL 1

Author Comment

by:LuckyDuck5281
ID: 19159538
We called MS on this one... after two week sof troubleshooting there was a registry key missing.
0
 
LVL 35

Accepted Solution

by:
David Todd earned 500 total points
ID: 19165204
Hi,

Glad to hear that its working.

Regards
  David
0
 

Expert Comment

by:rhellinger
ID: 25804835
What was the registry key?
0
 

Expert Comment

by:Jonathan Lizano
ID: 41838891
I have the same problem, with another versions of SQL, but the same diagnostic...
Anyone have the registry key that was missing?
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Help 27 46
SQL Error - Query 6 26
Run ColdFusion website locally 1 21
Proper Case SQL Command 2 13
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question