From my home server 'myserver1' I've tried to set up server 'myserver2'
as a linked server in SQL2000 for myself, userid=xxx, with these
--while on myserver1:
exec sp_addremotelogin myserver2,xxx
--while on myserver2:
exec sp_addremotelogin myserver1,xxx
Everything went fine. But when I tried to actually access the data on
myserver2 I received this error:
Server 'myserver2' is not configured for DATA ACCESS.
Can someone suggest what might be going on?