Re: Help installing SQL2000 on Win2003 - MSDTC resources required?

You will need to follow instructions in this link

http://support.microsoft.com/default.aspx?scid=kb;EN-US;817064

This http://support.microsoft.com/?kbid=301600 explains how to create the
MSDTC resource but you need another physical disk and network name so I
perform steps 7,8,9, 10,11,12,13 and use the quorum disk and sql server
network name as these resources and in the same group as the SQL Server
resource and make the SQLServer resource dependant on the MSDTC resource as
I had a few times when SQL Server starts before MSDTC and it fails to enlist
in a transaction.

This works for me.
--
Nik Marshall-Blank MCSD/MCDBA

"Ian" <nospam@xxxxxxxxxx> wrote in message
news:vbtqh1t44tnurchmk3781t94jb319l0adr@xxxxxxxxxx
>I am new to setting up clusters and also by no means a SQL DBA. I have
> some offsite help to assist me with SQL but we are both confused about
> how to set up MSDTC.
>
> I have read the webcast found here:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;888121
>
> And it speaks of setting up a dedicated disk. Other (older) resources
> talk about allowing MSDTC to share the Quorum disk.
>
> I am actually replicating an existing cluster of SQL 2000 on Win2000
> and it has MSDTC file on the Quorum drive.
>
> The clustered SQL server will not be hit hard. The app is running
> quite happily on dual P733s at the moment and a max of 80 users
> connect to the database (60 from the web). The new clustered hardware
> is P2800s.
>
> I don't want to set up more disks than I need. At the moment I have
>
> 2x36GB = RAID1 Quorum
> 2x73GB =RAID1 SQL Databases and Logs
> (I know logs should be on a seperate disk, I am hoping I can move them
> later on to 2x 36GB RAID1 when we decommission the existing cluster!)
>
> Hope you can help.
> Ian


.

Relevant Pages

  • Re: MSDTC doesnt work on SQL 2k in W2k3 cluster environment
    ... First, after reclustering the MSDTC, did you configure it within its own ... dedicated Cluster Resource Group? ... You will then need to take the SQL Server IP resource offline, ... How to enable network DTC access in Windows Server 2003 ...
    (microsoft.public.sqlserver.clustering)
  • RE: Failed resources
    ... catastrophic result, when I just move one resource to another node, like the ... > Node A hosts normally SQL Server 2K and File System ... > Cluster resource 'Disk Z:' in Resource Group 'Cluster Group' failed. ... > Cluster resource 'Disk V:' in Resource Group 'SQL Server Group' failed. ...
    (microsoft.public.windows.server.clustering)
  • Re: Creating Database (Urgently need help)
    ... Select the SQL Server group. ... Right click in the SLQ SErver resource, ... physical disk NOT in the list cannot be used for SQL data storage. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MSDTC in Windows 2008 Cluster...
    ... and just added the Data disk. ... I then created the MSDTC resource in a new ... clicked and moved it to my SQL application group in the cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Disk exchange on two-node MS SQL 2000 active/active cluster
    ... Bring both resource groups to the node you are logged into. ... I support the Professional Association for SQL Server ... >>> physical disk owened by the first node, ... >>> offline with cluster administrator) WHich is better? ...
    (microsoft.public.sqlserver.clustering)