Reply to Re: Link Server doesn't work except through query analyzer: MSSQL freezing / timing out

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация