SQL Server Performance

Windows Server 2003 Active/Active

Discussion in 'SQL Server Clustering' started by Jon M, Jan 12, 2004.

  1. Jon M Member

    Hi All,

    Anybody knows where I can find a step by step guideline on implementing SQL Server Clustering (Active/Active) under Windows Server 2003?

    Thanks.
    Jon M

  2. Twan New Member

    hi Jon,

    I don't think it has changed from installing it on Windows 2000...?

    One caveat is to not install Terminal Services on the W2K3 server, as this will screw up SQL

    Cheers
    Twan
  3. satya Moderator

  4. poshanchang New Member

    When I run comclust.exe to prepare the installation of SQL 2000 cluster. I got Cluster Administation MMC open and MS DTC does not install (no error) on Windows 2003.

    Can someone pls tell me why? I got MSCS running healthly already.

    Thanks a lot.

    Po.
  5. poshanchang New Member

    Got it ...
    http://support.microsoft.com/?id=301600

    How to Configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 Cluster

    Method 1: Use Cluster Administrator
    This section documents how to install MSDTC through Cluster Administrator on all nodes in a cluster. You only have to install the MSDTC once in Cluster Administrator and MSDTC will be configured on all nodes in the cluster. You do not have to install MSDTC manually on each node.
    Start Cluster Administrator. To do so:
    Click Start, and then point to All Programs
    In Administrative Tools, click Cluster Administrator.
    Create a Group Named "MSDTC Group" that contains a Physical Disk, Network Name, and an IP Address. To do so:
    In the Action Menu, click Create New Cluster, and then click OK.
    Follow the instructions that the New Cluster Wizard provides to create the MSDTC Group.
    Note: You can use an existing group with a Storage resource in it. However, Microsoft does not recommend that you create the MSDTC resource in the default Cluster Group or in the group that contains other program resources, such the Microsoft Exchange resources.
    Right-click the MSDTC Group, and then click NewResource.
    Type a name, such as MSDTC Resource.
    In Resource Type, click to select Distributed Transaction Coordinator, verify that the MSDTC Group check box is selected, and then click Next.
    In Possible Owners, click Next unless you do not want MSDTC to run on a particular node.
    In Dependencies, press and hold the CTRL key on the keyboard, select both the Physical Disk and Network Name that you created in step 2, and then click the Add button.
    Click Finish, and then click OK to confirm that the resource has been created.
    Right-click the MSDTC Resource, and then click Bring Online.

    Method 2: Use Cluster.exe
    This section documents how to install MSDTC with Cluster.exe. Cluster.exe is optimal for scripting the installation and configuration of MSDTC on several clusters. You only have to configure MSDTC once on a cluster and all nodes in the cluster are updated.
    At a command prompt, create a Group named "MSDTC Group" that contains a Physical Disk, Network Name, and an IP Address (or use an existing Group).

    Note: You can script the creation of Groups and Resources with Cluster.exe. See "Help and Support" and review the Cluster Commands Overview section.
    Type the following command at a command prompt:
    cluster clustername res "MSDTC Resource" /CREATE /GROUP:"MSDTC Group" /TYPE:"Distributed Transaction Coordinator"

    This command creates the MSDTC Resource.

    Note: If you are using an existing cluster group, substitute the name of the group with "MSDTC Group."
    Run the following commands:
    cluster clustername res "MSDTC Resource" /ADDDEP:"Network Name"

    cluster clustername res "MSDTC Resource" /ADDDEP:"Disk Q:"

    where Network Name is the proper Network Name resource that you are using, and Disk Q is the physical disk that is located in the MSDTC Group.

    These commands add the proper dependencies.
    Run the following command to bring MSDTC online:
    cluster clustername res "MSDTC Resource" /ON

    This will bring MSDTC online.
    Note: You cannot install MSDTC in a mixed-mode Cluster. All nodes in the Cluster must run Windows Server 2003 to use these methods. See "Help and Support" for more information.
  6. tumbleweed New Member

    Hi Poshanchang,

    I used method 1 to install MS DTC but I got this error in the DtcInstall.log.

    DTC Install error = 80, CreateFile, d:srv03rtmcomcomplusdtcdtcloglogmgrsrclogstor.cpp (2075)

    Did you get any error in the installation log?

    thanks
    tumbleweed

  7. satya Moderator

Share This Page