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 |
|
swissivan
Starting Member
30 Posts |
 Posted - 2013-04-29 : 00:04:11
|
| I would like to call a store procedure on server A to update table on server B.Case a) When server B's window firewall is off, store procedure runs correctly.Case b) When server B's window firewall is set with exception on msdtc.exe, it runs correctly.However, both cases a) and b) using DTCPING.exe showsDTCping log file: C:\Temp\DTCPING\SRV-185140.logRPC server is readyPlease Start Partner DTCping before pinging++++++++++++Validating Remote Computer Name++++++++++++Please refer to following log file for details: C:\Temp\DTCPING\SRV-185140.logInvoking RPC method on srv-10Problem:fail to invoke remote RPC methodError(0x6D9) at dtcping.cpp @303-->RPC pinging exception-->1753(There are no more endpoints available from the endpoint mapper.)RPC test failedCase c) I opened port 135, 1433, 1434, 5000~5050 on server B according to http://support.microsoft.com/kb/306843/en-us, I got a timeout.Any ports I am missing on server B? or do I need to care server A? Thanks. |
|
|
swissivan
Starting Member
30 Posts |
Posted - 2013-04-29 : 21:30:52
|
| Final opened same ports 135, 1433, 1434, 5000~5050 and it works. |
 |
|
|
|
|
|
MSDTC Ports?