Try using Linked servers.
Documentation can be found
here[
^]
After you have established a linked server, you can call your view like this,
SELECT
tb.id,
tb.column1,
tb2.column1,
tb2.column2
FROM dbo.Table2 tb2
INNER JOIN Server2.Database2.dbo.Table1 tb
ON tb2 = tb.id