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.