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 |
|
janebilclough
Starting Member
1 Post |
 Posted - 2009-04-29 : 05:42:36
|
| We are Receiving The Following Error when firing remote Stored Procedures from a local trigger"OLE DB provider "SQLNCLI" for linked server "Extranet" returned message "No transaction is active." New transaction cannot enlist in specified transaction coordinator" The Master Server is Windows 2003 Server Running SQL Server 2000 the Linked Server Is Windows 2003 Server Running SQL Express 2005We can get communication working between SQL 2000 and SQL Express 2005 with two machines connected to the same active directory domain however we cannot with the Extranet Machine which is on its own active directory domain.www.jndresponse.co.ukwww.jndunn.co.uk |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-07 : 02:05:08
|
Is DTC started?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
"No Transaction is active" error when firing store