Hi

Thanks for the info.

Just to recap, the server now has SP4 installed for SQL. Port 135 is open and according to MS, we also need to change the registry...

Hi

All connections to any server is based on a given SQL login. I have a login on the remote server which I use to connect using the SQL tools....

The linked server is setup to use "security context" and I supply a user name and password. As I mentioned, when I execute a simple select using the linked...

Thanks for the fast response.

I have 2 servers, one in Switzerland (local) and the other in Jersey. Both are running DTC. Both servers are running SQL2000 on W2K.

Incidentally,...