SQL Server Performance

how to log into the instances in cluster

Discussion in 'SQL Server 2005 Clustering' started by newbieal, Mar 27, 2008.

  1. newbieal New Member

    I've created a two node cluster enviornment (sql server 2005, win2003). My question is now when I install the sp's or do anything reg.the software, do I log into the actual server or the virtual server?
  2. satya Moderator

    Actual node name such as <machine name> and virtual server name is for SQL instance.
  3. newbieal New Member

    i'm not clear on the answer, so if i need to install instance and deal with anything related to that, I log into the VS? And for sp's install, etc to the actual <machine name>?
  4. melvinlusk Member

    Is your node active/active or active/passive?
    Say this is what you have:
    Server 1 Name: CORPDB1
    Server 2 Name: CORPDB2
    SQL Virtual Name: CORPDB1V
    SQL Virtual Name: CORPDB2V
    Instance 1 Name: A
    Instance 2 Name: B
    So, to log into one of your nodes, you would use CORPDB1VA or CORPDB2VB
  5. melvinlusk Member

    You'll have to log into the actual machine to install the Service Pack, CORPDB1, and then connect to the virtual instance to during the Service Pack install; CORPDB1VA.

Share This Page