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 - 2004-06-17 : 12:40:43
|
| I have been given a task to install SQL2000 on Win2003 cluster enviorment. I know a little bit about cluster and win2003 but need some help during the install process. My setup is as follows: I have 2 servers ProdA and ProdB resepectively, With virtual cluster names of ProdAAA and ProdBBB respectively for windows clustering. When I go to install Sql2000 on the first node of cluster it asks for Virtual name. Would this be ProdAAA or is this different SQL Virtual name. If it is a different name how and where do I create it. It also asks for Virtual IP is this IP of my PRODAAA or ProdA or is it totally different IP. Any help would be appreciated....Thanks,Jay |
|
|
gwhiz
Yak Posting Veteran
78 Posts |
Posted - 2004-06-17 : 12:58:33
|
| I would start with this article and do a lot of reading prior to doing this install. Once you have installed a cluster its pretty easy. But there are quite a few gotchas on the way.http://support.microsoft.com/default.aspx?scid=kb;en-us;243218&Product=sql2k |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-06-17 : 14:57:17
|
| The virtual name is the "public" name of your SQL server. It's what goes into the connection string.If you have two servers called ProdAA and ProdBB, then your SQL server virtual name might be something like ProdSQL. Whenever your cluster fails over, you will still be able to access ProdSQL because that's the virtual name. I believe that the Virtual IP is a totally different IP as well. Do some reading on this. Clustering is tough to get right the first time.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
SQL2000 Cluster