|
|
Posted by SQL Server Questions on 01/07/07 11:06
Thanks!
We've got to this point and are getting a "New transaction cannot
enlist in specified transaction coordinator" error.
Erland Sommarskog wrote:
> SQL Server Questions (farkerku@gmail.com) writes:
> > INSERT INTO table1(column1,column2)
> > SELECT A.column1, A.column2
> > FROM LINK_A.catalog_name.dbo.table2 AS A
> > WHERE A.column1 > xxxx;
> >
> > When we run this from the Query Analyzer, it completes with no problems
> > in a few seconds.
>
> And if you slap BEGIN/COMMIT TRANSACTION around it?
>
> > When we add the DTS Package as the ActiveX Script (VB Script) to the
> > Local Package, it times out at "obj_Conn.Execute str_Sql"
>
> I believe this is the problem is the increased security with DTC in Windows
> 2003. We had a problem with this a while back. This was what the support
> professional from MS told us:
>
> Let starts with a few troubleshooting steps, first take security MSDTC
> configurations at the minimum level. Component Services -> My Computer
> -> Right click proprieties ->MSDTC -> Select use local coordinator ->
> Security Configuration -> Enable Network DTC access, Enable remote
> administration, Enable Allow Remote clients, Enable allow inbound and
> outbound, Select no authentication required, Enable XA transactions and
> verify that NT AUTHORITY\NetworkService is set in DTC Logon account.
>
> Restart DTC service and SQL Server and test if issue persists.
>
> If problem persist please follow this KB article:
> http://support.microsoft.com/kb/306843 - How to troubleshoot
> MS DTC firewall issues.
>
> I think the step to restart SQL Server is unnecessary.
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|