February 19, 2005 at 3:39 pm
Hi,
I have a sql server 2000 sp 3 on a windows xp sp2. I run this code in query analyzer :
SET XACT_ABORT ON
begin distributed transaction
SELECT * FROM OPENROWSET('SQLOLEDB', 'p118'; 'user'; 'pass', [testdb]..testtable)
commit tran
I get this exception :
Server: Msg 7391, Level 16, State 1, Line 5
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].
p118 is in fact my local machine. I'm just trying to develop an application that should access a remote machine but unfortunatly I have only one server for now (my machine).
my @@servername returns the right machine name.
I have been to the component service and changed the security to allow remote client, inbound and outbound, selected no authentication required. The dtc is started and the account that starts the service is "NT AUTHORITY\NetworkService"
I get this message in the sql server 2000 log :
Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
I've search everywhere and can only find solutions that doesn't work for me.
Thanks for your help
Laurent
February 21, 2005 at 2:31 am
February 21, 2005 at 2:36 am
I already did that. No success.
Laurent
February 21, 2005 at 3:20 am
Back to basics - is the MS DTC service running and what account is it running under?
AT
February 21, 2005 at 3:30 am
MS DTC is running as "NT AUTHORITY\NetworkService".
In the component services, I have checked :
- Network DTC Access
- Allow Remote Clients
- Allow Remote Administration
- Allow Inbound
- Allow outbound
- No Authentication Required
My windows firewall is disabled.
Laurent
March 2, 2005 at 2:45 pm
You have to apply Elaine's fix and do a re-boot of your server for the changes to take affect.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply