Post reply

Multi Instances and their NAMES on SQL 2000 2-node cluster

  • January 15, 2009 at 10:44 am

    #71849

    I need to install 2 named instances on a SQL 2000 2-node cluster that has the following attributes:

    Machine 1:

    -- Phys Node 1 IP: 111.11.11.222

    -- Computer Name: SQLSeverCentral222

    Machine 2:

    -- Phys Node 2 IP: 111.11.11.333

    -- Computer Name: SQLSeverCentral333

    Virtual IP: 111.11.11.111

    Can I create 2 Instances on this cluster named as:

    MyVirtual\Inst1

    MyVirtual\Inst2

    I've been told the Virtual name above (MyVirtual) has to be unique for each instance creation on a Cluster as:

    MyVirtual_1\Inst1

    MyVirtual_2\Inst2

    BT

  • January 15, 2009 at 12:00 pm

    #927602

    Based on this Microsoft KB: http://support.microsoft.com/kb/260414

    In fact, you MUST specify a UNIQUE SQL Server Virtual Server name ---

    6Q: Can I have multiple instances of SQL Server for a single SQL virtual server on a failover cluster?

    A: No. You can run only one instance of SQL Server for each virtual server on a SQL Server failover cluster. However, you can install up to 16 SQL virtual servers on a failover cluster. The instance of SQL Server can be either a default instance or a named instance. The virtual server looks like a single computer to applications that are connecting to the instance of SQL Server. When applications connect to the virtual server, they use the same convention as when they connect to any instance of SQL Server. They specify the virtual server name of the cluster and the optional instance name (only needed for named instances): virtualservername\instancename.

    Therefore I must Use MyServer_1 and MyServer_2 as the SQL Server Virtual server names in the front end of th qualified Instance name.

    BT

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply