SQL 2008 clustering with Windows 2008

#**451**

You will have to manually create a MSDTC resource without the wizard. The
wizard won't let you share an anchor disk with SQL.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"OceanDeep via SQLMonster.com" <u46587@uwe> wrote

Quote:

If I allocate all disks to SQL during the SQL cluster setup as you
specified,
when I create MSDTC, it doesn't see any storage disk available and the
wizard
can't go next.

Here is how I create MSDTC, I right click 'Service and Application' and
select 'Configure a Service or Application'. This will bring up the High
Availability Wizard and then allow me to select DTC. This is the wizard
in
a later step to ask for storage. And since there is no storage, it can't
continue.

Geoff N. Hiten wrote:
Set up SQL normally.

Create MSDTC resource and set it to dependant on the SQL Data Disk after
moving it into the SQL application group.. You will be using the same
disk
for both MSDTC and SQL Data.

Ignore preferred owners.

Geoff,

[quoted text clipped - 42 lines]

Ocean

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...ering/200810/1

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2008 clustering with Windows 2008

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: SQL 2008 clustering with Windows 2008 - 10-27-2008 , 02:15 PM