Solved

MSDTC on Workgroup computers unavailable

Posted on 2007-11-20
5
1,495 Views
Last Modified: 2008-02-01
I have two computer, which when working with a server in the same domain work perfectly, however, these compuer are configured to use a Workgroup, not a domain. Both are running Windows XP SP2, both have XP firewall switched off, both installed with McAfee firewall, but have tested with this disabled, same results.

Both computer A and computer B have VS2005 and SQL 2005 Express installed, when computer B tries to access the database on computer A, everything works fine until MSDTC get involved, i.e. a Transactional update etc. Then the database access fails. In the Event Log it has several entries, all saying the same thing. MSDTC on server 'ComputerA' is unavailable, Error No 8501, Error Code 2. I have checked both computers and both have MSDTC running, and both configured to use the NT AUTHORITY\NETWORK SERVICE account. Both machine also work ok if accessing a database on an Windows Server 2003 computer with SQL 2005 Standard edition installed.

I can only assume it is somwthing to do with Workgroups, as when they both belonged to the same domain, computer B could work with computer A with no problem.

Thanks for any and all advice.
0
Comment
Question by:townsma
  • 2
5 Comments
 
LVL 11

Expert Comment

by:Zuhir Elgmati
ID: 20326057
0
 
LVL 6

Author Comment

by:townsma
ID: 20326122
Thanks for the prompt reply. I have looked at the sites you suggest, but I am pretty sure I have already visitied all of those, and certinly hve tried everything list in those, and many other websites.

This really is confusing, I have been working with MSDTC for about 7 years, in many versions of windows, and have always managed to find a way to make it work, but this one completely baffles me.

The MSDTC is running on both computers, using the NetworkService aacount, the firewall has the correct ports open, or has been disabled. Non transactional selects etc. work fine, it is only when MSDTC get involved. The correct settings are set in the MSDTC Security tab. As I said, if I try again an SQL Server on a Windows 2003 server, it works fine, if ai try against an SQL Server Express 2005 on Windows XP in a Workgroup, it does not work. Same computer just different results.

Thanks
0
 
LVL 6

Author Comment

by:townsma
ID: 20337541
I have now found the solution to this problem. Although in the MSDTC security page the reported username was NetworkService, apparently it was not the corret Network Service account. When I reselect the Network Service account from the search page. I discovered that the NetworkService account for the Domain that the computers used to be in, is spelt different to the Network Service account for the workgroup the computer is now in. One has a space , one doesn't. I guess this is why it worked against the server on a domain, but not against another workgroup connected computer.  

Very confusing I would have thought there would have been more consistency between the system generated account names.

Anyway fixed now.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 20521457
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
passing parameter in sql procedure 9 61
Event ID: 1202 / Source: SceCli 6 106
Which browser works with XP 16 170
create insert script based on records in a table 4 21
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
If you have done a reformat of your hard drive and proceeded to do a successful Windows XP installation, you may notice that a choice between two operating systems when you start up the machine. Here is how to get rid of this: Click Start Clic…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now