473,231 Members | 1,687 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

SQL Server Enterprise Manager could not start the service 'MSDTC'

KO
SQL Server Enterprise Manager could not start the service 'MSDTC' on server
'NTAS21'.

1722 - (The RPC server is unavailable)

I Setup A publication on a server called NTAS4D, then Pushed The
Subscription to another server called NTAS21. If I configure so that the
changes at the subscriber are not replicated to the publisher, all works ok,
I make a change at the publisher, it is replicated to the subscriber.

If I configure for updating at the subscriber, I am presented with a screen
stating that the following services must be started for replication to work:

SQL Server Agent on NTAS4D - Running
MSDTC on NTAS4D - Running
MSDTC on NTAS21 - Unknown

When I complete the wizard, I receive the message listed above.

The Servers are in two separate locations, each behind a NAT enabled router
using the internet to transfer data between the publisher and subscriber.

Any Suggestions will be greatly appreciated.
Thanks
Steve
Jul 20 '05 #1
1 8164
"KO" <no****@anyplace.com> wrote in message news:<bf**********@ngspool-d02.news.aol.com>...
SQL Server Enterprise Manager could not start the service 'MSDTC' on server
'NTAS21'.

1722 - (The RPC server is unavailable)

I Setup A publication on a server called NTAS4D, then Pushed The
Subscription to another server called NTAS21. If I configure so that the
changes at the subscriber are not replicated to the publisher, all works ok,
I make a change at the publisher, it is replicated to the subscriber.

If I configure for updating at the subscriber, I am presented with a screen
stating that the following services must be started for replication to work:

SQL Server Agent on NTAS4D - Running
MSDTC on NTAS4D - Running
MSDTC on NTAS21 - Unknown

When I complete the wizard, I receive the message listed above.

The Servers are in two separate locations, each behind a NAT enabled router
using the internet to transfer data between the publisher and subscriber.

Any Suggestions will be greatly appreciated.
Thanks
Steve


Have a look at Q191168 in the Microsoft Knowledge Base - there is a
good section on troubleshooting MSDTC connectivity issues. From your
description, it seems likely that the firewalls are preventing RPC
calls, and this is causing the problem.

Simon
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bennett Haselton | last post by:
I want to get an ASP.Net hosting account with my ISP, and I'm trying to find out what level of access to the server is requried in order for me to view the server in Server Explorer in Visual...
3
by: David Gray | last post by:
Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003,...
2
by: R Bolling | last post by:
ver: SQL-DMO Version: 8.00.760 I have the option to automatically start SQL Server on startup, but when it does start up, the SQL Server Service Manager does not have the green arrow indicating...
2
by: Robert M. | last post by:
Information: Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server Enterprise Edition. SQL Service pack is 3a. Member of domain ABCDomain. Server A is going to function as a...
0
by: Michael Bourgon | last post by:
I've been having the same problem for 2 weeks now. If anyone has any ideas, I'd love to hear them. We are using both SQL and Windows Authentication. I was running a Profiler Trace at the time,...
22
by: EP | last post by:
When running my asp.net hosting service (asp.net without IIS), on server 2003 with IIS not installed, I get the following when trying to process a request. "System.DllNotFoundException: Unable to...
8
by: M K | last post by:
I am a newbie at C# (VS 2005) and SQL Server(2003). I was able to create a db using my old pc and then copied it to my laptop to my project folder, I cannot connect to it nor can i create a db on...
0
by: titojermaine | last post by:
The problem is that after reducing MSDTC security to "No Authentication", it mostly seems to work correctly, except that after a brief period of inactivity (a few minutes), the first attempt to use...
1
by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= | last post by:
I have a web server 32 bit and SQL server 2005 64bit . Does msdtc support SQL server 2005 64bit with web server 32 bit?
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.