MSDTC Msg 8501

OS: Windows 2000

SQL Version: SQL 2000 - 8.00.818 (SP3) Standard

MSDTC Version: 03.00.00.3421

I am getting error message 8501 when I try to run any queries against this linked server from several environments (from Win2003 Server, XP). I have read that the MSDTC service needs to run under the NT AUTHORITY\NetworkService login. I cannot get it to be set to this login. How do I make this change. If I uninstall the service and reinstall, I still get it to default to local system account.

What I am needing is:

How do I set the NT Authority\NetworkService account for the MSDTC service?

How do I set the MSDTC service to run with remote connections comming in?

Please let me know what other information you will need.

Thank you for any help you may give.

One of the KBA refers:

Make sure that the Log On As account for the MSDTC service is the Network Service account. To do this, follow these steps:

a.

Click Start, and then click Run.

b.

In the Run dialog box, type Services.msc, and then click OK.

c.

In the Services window, locate the Distributed Transaction Coordinator service under Name in the right pane.

d.

Under the Log On As column, see whether the Log On As account is Network Service or Local System.

If the Log On As account is Network Service, go to step 2. If the Log On As account is Local System account, continue with these steps.

e.

Click Start, and then click Run.

f.

In the Run dialog box, type cmd, and then click OK.

-

Enable MSDTC to allow the network transaction. To do this, follow these steps:

a.

Click Start, and then click Run.

b.

In the Run dialog box, type dcomcnfg.exe, and then click OK.

c.

In the Component Services window, expand Component Services, expand Computers, and then expand My Computer.

d.

Right-click My Computer, and then click Properties.

e.

In the My Computer Properties dialog box, click Security Configuration on the MSDTC tab.

f.

In the Security Configuration dialog box, click to select the Network DTC Access check box.

g.

To allow the distributed transaction to run on this computer from a remote computer, click to select the Allow Inbound check box.

h.

To allow the distributed transaction to run on a remote computer from this computer, click to select the Allow Outbound check box.

i.

Under the Transaction Manager Communication group, click to select the No Authentication Required option.

j.

In the Security Configuration dialog box, click OK.

k.

In the My Computer Properties dialog box, click OK.

|||

I have found these instructions, but they are for Windows 2003 Server and I am running Windows 2000 Server. I do appreciate your reply and I followed the directions as outlined, but the My Computer Properties within the Component Services does not show these options.

Within the Distributed Transaction Coordinator service properties I cannot get it to log on as the Network Service. I have un-installed MSDTC, deleted the registry key, re-installed MSDTC and it defaults to the Local System account, not the Network Service account. Now distributed transactions are receiving the error Msg 8501. I have deleted the linked server and re-created the linked server and I am still getting this same error.

|||

Strange, I've followed the same on a windows 2000 SP4 advanced server box without any issues.

Please specify the WIndows OS service pack level too.

GeneralSQL wrote:

I have found these instructions, but they are for Windows 2003 Server and I am running Windows 2000 Server. I do appreciate your reply and I followed the directions as outlined, but the My Computer Properties within the Component Services does not show these options.

Within the Distributed Transaction Coordinator service properties I cannot get it to log on as the Network Service. I have un-installed MSDTC, deleted the registry key, re-installed MSDTC and it defaults to the Local System account, not the Network Service account. Now distributed transactions are receiving the error Msg 8501. I have deleted the linked server and re-created the linked server and I am still getting this same error.

|||

Microsoft Windows 2000

5.00.2195

Service Pack 4

It is not advanced server, but the standard edition.