| Kekilie 2005-10-13, 6:00 pm |
| Hi,
I have trouble using a SQLAdapter to get data from a remote SQL Server.
There are two servers in this solution; server "A" contains BizTalk Server
2004 and its local MS SQL Server, server "B" contains an another MS SQL
Server with business data.
The SQLAdapter on server "A" calls a stored procedure on server "A", and
this procedure selects data from a remote SQL Server on server "B" through a
linked server, created in MS SQL Server on server "A". When running BizTalk I
get this errors in EventViewer :
1.
"<?MSSQLError HResult="0x80040e14" Source="Microsoft OLE DB Provider for SQL
Server" Description="[OLE/DB provider returned message: New transaction
cannot enlist in the specified transaction coordinator. ]"?>"
2.
"MS DTC is unable to communicate with MS DTC on a remote system. MS DTC on
the primary system established an RPC binding with MS DTC on the secondary
system. However, the secondary system did not create the reverse RPC binding
to the primary MS DTC system before the timeout period expired. Please
ensure that there is network connectivity between the two systems."
If I change the stored procedure to select data from a local table on server
"A" it works perfect! The only problem is that the data I need is on server
"B"... 
I have tried to troubleshoot with DTCPing.exe.
Get this RPC error on server "A" : "There are no more endpoints available
from the endpoint mapper".
Get this RPC error on server "B" : "The RPC server is unavailable."
So it seems like I have a RPC problem.
I have tried troubleshoot RPC with an article
(http://support.microsoft.com/defaul...kb;en-us;306843) but got
stuck on step 8 - I dont know how to make sure that the EPM is open in both
directions...
Anyone who is familiar with using SQLAdapter for getting data from a remote
SQL Server? Or anyone who know why I get this RPC problem and how I can fix
it?
Please 
Regards,
Cecilie
|