Hi,
I'm trying to run a stored procedure with linked servers on Sql2k over
a broadband connection where sql server is setup for port forwarding
and am getting the error :-
Server: Msg 7391, Level 16, State 1, Line 10
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'
ITransactionJoi n::JoinTransact ion returned 0x8004d00a].
1 pc is 2003 server, the other windows 2000 professional.
MsDTC is running at both ends with network transactions ticked.
TurnOffRpcSecur ity to 1 in the registry
I've read that you need to be able to run the sp_addlinkedser ver by
computer names, ie. the name must be the HOSTS file. Does this mean I
need a VPN for this all to work or is there a solution for port
forwarding ?
I'm trying to run a stored procedure with linked servers on Sql2k over
a broadband connection where sql server is setup for port forwarding
and am getting the error :-
Server: Msg 7391, Level 16, State 1, Line 10
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'
ITransactionJoi n::JoinTransact ion returned 0x8004d00a].
1 pc is 2003 server, the other windows 2000 professional.
MsDTC is running at both ends with network transactions ticked.
TurnOffRpcSecur ity to 1 in the registry
I've read that you need to be able to run the sp_addlinkedser ver by
computer names, ie. the name must be the HOSTS file. Does this mean I
need a VPN for this all to work or is there a solution for port
forwarding ?