Can you get them to drop the firewall for a short period of time so that you can prove this si the problem? If its the firewall I would guess that you need to get them to open up the port for SQL Server.
>>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