Solved

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

Posted on 2007-04-11
8
3,133 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
 
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
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 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now