Access of MSDTC Server

[Matthias J. Lüthi]

How can I get access to an MS DTC server. when i install the client and
wan't to configure the server. the client says, that there is no MS DTC
server running, but the MS DTC server is running, on the specified computer.

is this a problem of user rights?

thanks for any information

Matthias

[John Steely]

Matthias,
Quick question: is the MSDTC Service running on the server?

John Steely
DaVinci TWG

[Jeff Mogielnicki]

I'm not sure if this will help but, remember If SS Commerce edition is
on a different machine than SQL, both machines must be running the
MSDTC service.

See the commerce edition documentation:
http://localhost/siteserver/docs/grc%5Finstalling%5Fbtkr.htm

-Jeff

On Sun, 21 Mar 1999 02:21:35 GMT, John Steely <davinc...@home.com>
wrote:

[Matthias J. Lüthi]

But what is the easiest way to install MSDTC Client. I tried with MS SQL
Utilities, but it doesn't work...

Matthias

Jeff Mogielnicki wrote in message
<36f7fc0f...@msnews.microsoft.com>...

[John Gault]

Let's assume that your web server and your SQL server are on two different
machines.
On the web server box, the MSDTC service would have been installed as part
of the IIS4 / NT Option Pack setup. On the SQL server box, the MSDTC
service would have been installed as part of the SQL Server (version 6.5?)
setup.

So, the first thing to do is to see if the service is present on both
machines. One easy way to tell is to look in the Ctrl-Panel's Services
applet and see if you have an entry for MSDTC.

Assuming that you do find an entry, note the MSDTC Service's startup
options. It should be set to 'Automatic' on both machines, and also, you
have to change the identity of the account the service executes under from
'system account' to an account common to both machines which also is in each
machine's Administrators group. We use a domain account to make it easy.
BTW, you can find this step documented in the readme file for MTS.

Lastly, install the SQL Server client utils on the web server (if you want).
That way you can use SQL Enterprise Manager to attach to the remote SQL
server and verify that you are making a good connection on MSDTC. What I
mean is, you should be able to see that the status of the MSDTC is Normal
(there should be a green light in the icon for Distributed transaction
Coordinator.) Final note: if you get an error trying to open that in SQL
Enterprise manager, you may not have set up your client to use a 'trusted'
client connection. The 'SQL Client Configuration Utility' icon is what you
use to set that up. Pick a Netlib type of either Named Pipes or
Multiprotocol as your default.

Good luck.

Matthias J. Lüthi wrote in message ...