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:29:37
|
| 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 |
|
|
gkrishn
Starting Member
16 Posts |
Posted - 2005-10-27 : 13:27:45
|
| Too complicated explanation!!!if you have instace like Dog1\D1 then 1)your computer name should be Dog1 (right click my computer>properties>computer name tab >network identification.Then you cant instal other server in same with Dog2\D2.Make this clear first .What is your computer name for TOM-Rajiv |
 |
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2005-10-27 : 13:48:11
|
Dog1 is my Virtual Server name. Tom is the name of the physical server, where the OS is installed. DOG1 and DOG2 are virtual server names that failover within cluster. D1 and D2 are instance names of these virtual server names. So if I open up SQL Server Enterprise Manager on my "TOM" server. I can see Dog1\D1 and Dog2\D2 under the SQL Server Group and I can see Databases underneath of these names. Problem is I can't make an ODBC connection from my desktop or I cannot connect an application to these databases.Any help is appreciated.quote:
Originally posted by gkrishn
Too complicated explanation!!!if you have instace like Dog1\D1 then 1)your computer name should be Dog1 (right click my computer>properties>computer name tab >network identification.Then you cant instal other server in same with Dog2\D2.Make this clear first .What is your computer name for TOM-Rajiv
|
|
|
|
gkrishn
Starting Member
16 Posts |
Posted - 2005-10-27 : 13:54:22
|
| how about connecting using QA or EM from remote servers? or you have pbm only when using appli?-Rajiv |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Installation