all groups > sql server connect > august 2004 >
You're in the

sql server connect

group:

Reinstalling MS DTC



Reinstalling MS DTC Craig Kenisston
8/17/2004 2:21:02 PM
sql server connect:
Here I go for last time, I promise.

I uninstalled MS DTC (in an stupid attemp to avoid a distributed transaction
to start), by doing :

net stop MSDTC
MSDTC - uninstall


After some charitative aim told me what I wanted to do is not possible, I
decided to reinstall :

MSDTC -install
net start MSDTC

I can see the "Distributed Transaction Coordinator" item, in the service
manager, it is running for sure.
Also, the Services console shows it as "started".

But I still getting the message MSDTC on server 'myserver' is unavailable'.

I've repeated the operation a couple of times, to be sure (deinstall and
reinstall) and still not working.

Actually, I recall yesterday I was able to stop and restart MSDTC without
problem, several times, but I was just doing that : stop & restart.
Today it happens that I "uninstall" it and then it is not like before any
more.

I'm using an account with Administrator privilegies (Windows 2000 Advanced
Server / SQL Server 2000 Enterprise)

Is there something else I need to do to ? should I need to restart the SQL
Server ? SQL Agent ?
Any help is greatly appreciated.


Regards,

RE: Reinstalling MS DTC rboyd NO[at]SPAM onlinemicrosoft.com
8/18/2004 7:46:28 PM
If you remove and then re-install MSDTC, you may need to restart SQL Server
for it to be able to use it. MSDTC has to be running when SQL Server starts
or it cannot use it. I am not sure this will resolve the problem, but I
would stop MSDTC and SQL Server. Then start MSDTC and verify that it is
running. Then start SQL Server.

Rand
This posting is provided "as is" with no warranties and confers no rights.
Re: Reinstalling MS DTC Michael D. Long
8/19/2004 10:48:03 PM
Refer to the following MSKB article:

How To Reinstall MS DTC for a Nonclustered Windows 2000 Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;279786


--
Michael D. Long
Microsoft MVP - Windows SDK

[quoted text, click to view]

AddThis Social Bookmark Button