Error: -2147168246 Distributed transaction error

[kmalhotra]

This is the scenario -
We are trying to point an asp web server to a SQL 2000 database thought a WAN link. If we point the web server to a database server lying in the same LAN it works fine.
If we point the same web server to the same database across the WAN, we get the following error.

Driver={SQL Server};Server=aspsql;Database=TEST0213;User id=AgencyUser;Password=asp;AgencyId=174 sp_GetUser SP String: sp_GetUser 1,174,1 Error: -2147168246 Description: [Microsoft][ODBC SQL Server Driver]Distributed transaction error

The only difference I can see between the two scenarios is the physical distance between the web server and database server.

Please help. Could this be a subnet issue?

 

[GiaBetiu]

Can you acces that SQL remote server? Have you a router between remote site and central site ( i suppose yes)?
Have you some special filtering on your router? Gia Betiu
giabetiu@chello.nl
Computer Eng. CNE 4, CNE 5, MCSE Win2K