Hi,

I have a SQL Server that gets and updates data on another remote server (using it as a linked server). The fact is that it worked very well on things like:

Update
   C
Set
   C.UpdateField = D.ValueField
From
   MyRemoteServer.MyDB.dbo.MyTable C
   INNER JOIN MyLocalTable D
      ON C.JoinField = D.JoinField

and other stuff like that...

Recently they installed a firewall (on another local server) after that I can only access the remote server through the Query Analyzer or as a registered server on Enterprise Manager but I can't access it as a linked server, it says "Error 17: Server does not exist or access denied." whenever I go to it on the Enterprise manager to see the tables. It worked very well before they install the firewall I did not change the configuration of the linked server so I don't know why it doesn't work as before. Can anybody help me? Or is there a another way that a stored procedure can do such things? I would appreciate it very much.

TIA

Luis