I've linked the servers together with sp_addlinkedserver.
They are in sysdatabases, they show up with sp_linkedservers and I can refer to them in code with the following:
Select * From server1.mydb.dbo.mytable
I get an error message saying that server1 is not set up for DATA ACCESS.
? What Gives ?