Background.

I have a VB6 Application running on windows server 2003 in component services

Applications connect to multiple databases.

One database is SQLServer 2000 running on a windows 2003 server
One database is SQLServer 2000 running on a windows 2000 server

First it connects to the sql database on the windows 2003 server to initialize some resources. I was getting this error at this point but have since resolved it by configuring MSDTC access over the network per the following article on msdn

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql"

Now I am over that hurdle but I am getting the same error when trying to execute a command on the database that is running windows server 2000. The thing is the settings which allow MSDTC over the network are not available on windows server 2000. Supposedly network access is enabled by default. Now when trying to create a transaction on a sql server 2000 database which runs on windows server 2000 from a windows server 2003 applications server i am getting the error:

-2147168246 Microsoft OLE DB Provider for SQL Server compute failed New transaction cannot enlist in the specified transaction coordinator.

Any insight would be greatly appreciated.



Thanks,

Chris