Anilrgowda

Question: Running Vista Ultimate on a Domain trying to connect to a SQL 2000 (latest service pack) Cluster using ODBC Connection and get to the second screen "How should SQL Server verifty..." and when I hit next it thinks for a long time then get this error popup dialog box:
---
Connection Failed SQLState: '01000'
SQL Server Error: 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open
(Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver[DBNETLIB]SQL Server does not exist or access denied
---------
I CAN connect to our other Database Server running the same version but NOT a cluster environment. No matter which database I try to connect to on the cluster I get the above error. It is not a permissions problem as the SA gets the same error.

Now for the weird part: One user in our environment did an upgrade from Windows XP to Vista (the rest of us did a fresh install). He IS able to use the software that connects to the database!

Any help is appreciated.

Anilrgowda

What name are you using when you atempt to connect to SQL Server running on a cluster> There is no functional difference between connectiong to a stand alone machine or connecting to SQL SErver running on a cluster. The only difference is that on a cluster you connect using the virtual SQL Server name instead of the machine name.

Are you using the virtual SQL Server name, the cluster name or the actual node name when you attempt to connect? Also in many instances clustered SQL Servers are named instances. If this is the case are you specifying the instance name when you attempt the connection.

If you know the ip address of the virtual SQL Server and the port number it is listening on, you cna attempt to connect using <ip address>,<port number>