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 |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2006-03-21 : 12:12:57
|
| When i do a BEGIN TRAN to a SQL server sitting on Windows 2003 Server from a SQL Server Sitting on Windows 2000 Server,the Transaction hangs and if I try o kill it the Transaction is in ROLLBACK State.I tried setting the Properties for the MSDTC and restarted the Windows 2003 Server but in vainIt still hangsDid any one come across this problem?Thx |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-21 : 13:50:06
|
| how is DTC configured on your 2003 system? Look under Administrative Tools --> Component Services cpanel --> Component Services heading --> Computers folder --> Right Click Properties on My Computer --> MSDTC tab --> Security Configuration buttonWhat exactly is checked in this security configuration section?-ec |
 |
|
|
|
|
|
MSDTC