I have two sql servers (express 2008) on the same domain. On one I can write views that include tables/views from the second server, but on the second server I can not do the same.
I'm using the standard [servername].[database].[schema].[view]. It seems that the second server simply can't find/return the view from server one.
I've checked settings and things seem to be setup identically.