March 6, 2002 at 11:52 am
Can, should or should not the SQL Server Virtual Server name be the same as the Windows Cluster Virtual Server name? Before installing I assumed that the Windows Cluster Virtual Server name would be used for the SQL Server Virtual Server name. Then the installer wouldn't let me. It said the name was already in use.
March 6, 2002 at 7:49 pm
This came from SQL 2000 BOL update version on the SQL downloads section "Creating a Failover Cluster" or can be found on MSDN here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp where you can find more info.
Naming a Virtual Server
SQL Server 2000 depends on distinct registry keys and service names within the failover cluster so that operations will continue correctly after a failover. Therefore, the name you provide for the instance of SQL Server 2000, including the default instance, must be unique across all nodes in the failover cluster, as well as across all virtual servers within the failover cluster. For example, if all instances failed over to a single server, their service names and registry keys would conflict. If INST1 is a named instance on virtual server VIRTSRV1, there cannot be a named instance INST1 on any node in the failover cluster, either as part of a failover cluster configuration or as a stand-alone installation.
Additionally, you must use the VIRTUAL_SERVER\Instance-name string to connect to a clustered instance of SQL Server 2000 running on a virtual server. You cannot access the instance of SQL Server 2000 by using the computer name that the clustered instance happens to reside on at any given time. SQL Server 2000 does not listen on the IP address of the local servers. It listens only on the clustered IP addresses created during the setup of a virtual server for SQL Server 2000.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 7, 2002 at 6:35 am
Thanks for the information. I hadn't seen that page yet.
March 7, 2002 at 6:54 am
Apprently they did quite a few updates from the original BOL for SQL 2K that make it more usefull.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply