Friday, February 17, 2012

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
FalconerHi
"Falconer" wrote:
> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best links
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>> Hi friends,
>> One simple and maybe silly question. Is DTC cluster resource a necessary
>> prerequisite for SQL Server to operate in cluster environment? If so,
>> why?
>> And it'd be great if anyone can direct me to any resource about DTC
>> internals. Not just setup & configuration but how it works on low level.
>> Thanks in advance.
>> Falconer
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John

No comments:

Post a Comment