Just a thought, can you reverse this and get from the server behind the firewall to the server you are working on?
>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