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 |