>Just a thought, can you reverse this and get from the server behind the firewall to the server you are working on?
>
>
>
>

Yes, I can but I can't use any SQL command that involves two o more tables from both servers, it takes forever and never ends that's why I had to go the other way in which it does work.

Thanks,

Luis


>>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