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 ?