I'm having trouble setting up a linked sql server. I was able to set one up
successfully but not the second one. Both servers are sql 7.0. Both are
replicating (merge) to one another. At first I was getting "server not
found". I tried several things. I set up an alias name in Client network
utility so the remote server and the linked server wouldn't have the same
name. Then I ran sp_addlinkedsrvlogin and the error I get now is "Server
'sql_srv' is not configured for DATA ACCESS."
Any advice as to what I can try next?????