October 16, 2008 at 12:19 pm
If someone can fix this it would be amazing!
Box1 =1 server (W2K sp4) running SQL2000 sp4 on network A
Box2 =1 pc (XP Pro Sp2) running MSDE (firewall turned off) on network B
Box2 is a Linked Server in Box1
Physical firewall between the networks. Port 135 open and communication enabled between the 2 boxes.
We have a proceedure that creates a temp table on Box1 based on a select statment on a table from Box2. This works fine.
We then attempt to update a table on Box2 based on whether or not a record exists on Box2 that exists on Box1 in #temptable.
SET XACT_ABORT ON
begin tran
update [Box2].dbname.dbo.tablename
set columnvalue = current_timestamp
where xGuid in
(select xGuid
from #temptableBox1)
**have change begin tran to "begin distributed tran" - same error occurs.
ERROR is:
Server: Msg 7391, Level 16, State 1, Procedure procedurenameBox1, Line 58
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
Have read KP839279 ad nausum... all MSDTC settings are correct on the XP box.
Any comments ideas to resolve this will be appreciated
October 16, 2008 at 12:30 pm
how about the MSDTC settings server side ?
Is MSDTC running ?
Is it configured to accept your time of server-server connection ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 16, 2008 at 12:56 pm
re: MSDTC on server
Yes it is running (and I bounced the service, and then the whole server a few times)
Not sure what you mean by server-server time?
Not really a network person but then here I am 🙂
October 17, 2008 at 12:39 am
You need to configure the security settings for MSDTC at the server to accept the type of connections you want.
This gui is different, depending on the service pack of the windows version your server is on.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply