dbTalk Databases Forums  

DTC, Sql Cluster & firewall

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


Discuss DTC, Sql Cluster & firewall in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dario Sala
 
Posts: n/a

Default DTC, Sql Cluster & firewall - 06-23-2004 , 09:02 AM






Our scenario:

- web servers windows 2003 with web application using com+ activex Dll, on
DMZ
- sql server Ent 2000 on windows 2000 server advanced, in cluster
active/passive, on LAN

After activating on both nodes the DTC service using comclust command, i
still have errors "New transaction cannot enlist in the specified
transaction coordinator" on web servers.

Then i found the Microsoft Knowledge Base Article 250367
(http://support.microsoft.com/default...en-us;250367):
"Configuring Microsoft Distributed Transaction Coordinator (DTC) to Work
Through a Firewall" that explains how to modify registry so to control RPC
dynamic port allocation (add new key under
HKEY_LOCAL_MACHINE\Software\Microsoft\Rpc ).

But i don't know which are the correct steps to apply these modifications on
a cluster environment.

Have i to apply on both nodes ?
Which one first ? The active one or the passive one ?

I've just tried, but if i apply on both node, then when i restart the
passive cannot start Cluster service !

Help please!

Thanks in advance.

Regards,
Dario








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.