Hi,

I didn't created the port.

With DTCPing I was able to understand what was the port used by SQL server and check that it was only working on one direction.

The problem...

Hi,

The port was the 4343.

This article helped me tracking the problem:

http://support.microsoft.com/kb/306843

The use of DTCPing is explained.

By

Hi,

Problem solved!

It was a problem on the network configuration.

The port usar by MSDTC was only open on one direction 🙁

Know it's working,

Thanks,

João

Hi,

Yes, I have.

Every time I made a change I've rebooted both servers.

João

Hi,

On Object Explorer select Security and then Logins.

Select the user you need to check and then, on the rigth side (Summary) rigth click the mouse and choose "property". A...

Hi,

Same problem here!

I'm using two SqlServer 2005 both running on Windows Server 2003 Standard Edition SP1.

Both doesn't belongs to a Domain. They are configured in they own workgroup.