Sometimes, especially in a VM env, the firewall can cause these problems. In the firewall on the server allow it to open port 1433, what SQL SErver uses to listen...

Here is the basic Syntax:

update table1

SET serverowner = (

select serverOwner

from table2

where table1.servername = table2.servername

)

where servername in (select servername from table2)

GO

Sorry for the late reply, I overlooked some older emails...