Named instances | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Named instances

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
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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.