SQL Server Performance

Named instances

Discussion in 'SQL Server Clustering' started by FDB, Mar 23, 2005.

  1. FDB New Member

    Hi All,

    I want to setup an active/active virtual server configuration with SQL server 2000 using 2-node under Windows Server 2003, I will call them as SQLVS01 and SQLVS02.

    Can I have both instances called SQLVS01 on Virtual Server 1 and SQLVS02 on Virtual Server 2, or need call SQLVS01 and SQLVS02INST2 ?

    Thanks,

    FDB
  2. satya Moderator

    The second node must use a named instance to install SQL Server. In other words, the client may connect to the SQL Server with the name VIRTUALNAME2INSTANCENAME. Notice that the virtual server name for the second SQL Server is not the same as the first node. The

    When installing SQL Server into an Active/Active cluster, you will install the software twice. The SQL Server service will actually be set to startup manual and will be started by the cluster. When you look at the services on each node, you will notice that the SQL Server service is installed on both nodes but is only started on the node that owns the SQL Server resource.





    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page