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.
| Author |
Topic |
|
ykhanvilkar
Starting Member
1 Post |
 Posted - 2007-08-07 : 11:19:54
|
| Hi,I have following environmentServer 1 with Win2003 SP 2 & SQL 2005 with SP2Server 2 with Win2003 SP 2 & SQL 2005 with SP2Now, when I try to use a link server & fire an update statement wrapped in BEGIN TRANSACTION & COMMIT TRANSACTION statements, I get an error OLE DB provider "SQLNCLI" for linked server "<Link server name appears here...>" returned message "No transaction is active.".Msg 7391, Level 16, State 2, Line 2The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "<Link server name appears here...>" was unable to begin a distributed transaction.I have setup everything required for the MSDTC as mentioned in http://support.microsoft.com/kb/329332 , but still it doesnt work (Even after restarting servers)Then, I tried with Windows Server 2003 SP 1 on Server 1, it works.Server 1 is my source in this link server usage environment & Server 2 is the destination server.Wondering if there are some bugs in Windows Server 2003 SP 2 ???I have tried setting up SET XACT_ABORT ON & also tried using BEGIN DISTRIBUTED TRANSACTION, still no luck |
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
|
|
|
MS DTC isnt working for WIndows 2003 SP2