Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 MSDTC

Author  Topic 

prash.dba
Starting Member

5 Posts

Posted - 2010-07-12 : 07:08:43
Hi,
We have a windows 2003 cluster with sp2, SQL Server 2005 cluster , active active. The MSDTC was installed and put on the cluster without the enabling option "Enable network DTC access".

Could you please let me know the best way to enable it. I think we have to enable it before putting msdtc on the cluster.

What I would want to do , is delete the msdtc resource on the cluster.enable the network dtc access on both nodes , put the msdtc resource back into the cluster.

Let me know if there are any more suggestions and some steps for the above.

Thanks
Prash.dba

sql-programmers
Posting Yak Master

190 Posts

Posted - 2010-07-19 : 07:38:43
Did you checked the links,

http://support.microsoft.com/kb/817064

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



SQL Server Programmers and Consultants
http://www.sql-programmers.com/
Go to Top of Page

Typhon
Starting Member

2 Posts

Posted - 2010-07-21 : 05:53:49
Take the resource offline and modify the securoty configuration. It is not required to take MSDTC off the cluster resources.

Go to Top of Page
   

- Advertisement -