473,837 Members | 1,575 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 8191
"KO" <no****@anyplac e.com> wrote in message news:<bf******* ***@ngspool-d02.news.aol.co m>...
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
2640
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 Studio .Net, where you can see the available database, expand it to get a list of tables, etc. What level of access is required? Of course you need to have an account with the right user rights, but is there some specific service that needs to be...
3
24297
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, Standard edition MS SQL/Server 2000 Oracle 9i Client kit (OLEDB & ODBC) & Enterprise management tools
2
3249
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 that it is active. When I double-click it to display the SQL Server Service Manager, it shows the name of the server, but no services in the drop-down box. When I start Enterprise Manager I see an instance of MSDE where someone installed an...
2
4290
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 Distributor. Location: New York. Server B: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server Standard Edition. SQL Service pack is 3a. Member of domain ABCDomain. Server B is going to function as a Subscriber.
0
2323
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, and am going through it now but have not seen anything yet. Thanks in advance. About once a week, at no fixed time (but so far, between 8am and 11am), my SQL Server 2000 on Windows 2000 (8.00.679) will stop responding. New connections will...
22
3311
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 load DLL (aspnet_isapi.dll)." Of course the dll is able to be found, it's still in the framework directory and for grins I even put it in my service's local directory. This is apparantly server 2003 not allowing asp.net to be run if IIS was not...
8
3282
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 my laptop. I belive its an access issue but I don't know what to do. When i go into Enterprise Manager it shows a red dot for (local) and when i try to connect(click) to it i get the following: A connection could nto be established to...
0
1511
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 DTC fails, but subsequent attempts are successful, until inactivity again. The original environment was a single machine with SQL Server installed and a service on another machine that would connect to the same SQL Server but utilizing different...
1
2170
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
10902
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10583
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10642
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7824
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7013
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5680
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5863
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4481
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3128
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.