SQL Server Performance Forum – Threads Archive

linked server problem

I use a trigger which I update a linked server and this is working very good in SQL 2000. But after I migrate the database to SQL 2005. The trigger is not working with linked server any more. I remember I need to start the distributed transaction coordinator in service manager. But I couldn’t find anything similar to this in SQL 2005. Is it somewhere I need to start? I got an error message like following: Msg 7391, Level 16, State 2, Procedure EAI_ADM_STUDENT_ins_upd_trg, Line 804 The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "10.2.0.119" was unable to begin a distributed transaction. Please help. Thanks.

Check SAC… Open Surface Area Configuration for Services and Connections…
Click on remote connection and see it is configure for "local and remote connections" by default it "Local connecions only"
Mohammed U.

Thanks. Unfortunately it is set to local and remote connection and use TCP/IP only already.So could be some other problems.

I had this same problem, try what I posted here: http://www.dbforums.com/showthread.php?t=1612211 SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
www.elsasoft.org

Also this KBAhttp://support.microsoft.com/kb/306212 handy for further resolution. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

I have read the articles and tried. But it doesn’t work.

is SQL Server 2005 in a named instance. I am having the same problem —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

You need to make sure the MDAC version and patching levels on all SQL 2005 instances must be same including the operating system ones. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Sorry. The problem is still there.

Hi, I hope these two link will help u http://geekswithblogs.net/mrnat/archive/2005/04/13/33403.aspx http://technet2.microsoft.com/Windo…0636-4b85-8ada-c2b99f8555ac1033.mspx?mfr=true Madhu

]]>