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.