Sorry, I just got back to UT (I was very busy). Yes, the people configuring the firewall closed several ports some of them prevented intercomunicate between the two sql servers. They fixed that after insisting a lot.
Thank you,
Luis
>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