Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2005-10-27 : 12:28:50
|
| I am new with SQL and have a question regarding SQL Connections. I have 2 Win2003 Servers(tom and Jerry) setup with Microsoft Cluster installed in Active-->Active Mode. Also, on both of these servers, I have SQL 2000 installed in Active-->Active mode as well. So I installed SQL2000 on Tom first and gave the SQL server name of Dog1 which has and IP assigned to it, at the same time I gave an instance name of D1. So now my SQL on Tom server reads Dog1\D1. I did another installation on Tom and gave it Dog2\D2. Than I went and installed SQL again on Jerry, this time and gave name of Cat\C3, and Cat\C4.Now in my DNS, I have Dog1, Dog2, Cat3, Cat4 defined with an IP I assigned. Problem I am running into is I cannot connect my application or make and ODBC connection to Dog1\D1, Dog2\D2, Cat3\C3 or Cat4\C4. I am getting Server not found message.Can anyone help me and tell me where I am going wrong, as I need to get this app up ASAP.Thanks,Jay |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-27 : 12:59:56
|
| In Cluster Administrator, how many groups do you have? There should be 3, one for the cluster, and one for each virtual server. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-27 : 15:00:58
|
| Did you create an alias using Client Network Utility on the machine where the application resides? All SQL instances are listening on different ports, right?Tara |
|
|
|
|
|
|
|
|
SQL Installation