Unanswered: Linked Server Error from SQL 7 to SQL 2000 Cluster
I've recently upgraded a SQL 7 active/active cluster to a Windows 2000 muliple instance cluster. Everything is fine apart from the fact that i get an error message when creating a linked server from another SQL 7 server to one of the nodes in the SQL 2000 cluster.
I have tried through enterprise manager and using sp_addlinkedserver.
I am using the Microsoft OLE BD Provider for SQL server and connecting using the SA login. The SA login and password are the same on both boxes.
In both cases the server appears in enterprise manager but I get the message "ERROR 2: Access Denied" when I double click on tables or views.
I have no problem setting up a linked server from the SQL 2000 Node to the SQL 7 node.
Anyone got any ideas? I had a full head of hair yesterday and about 30% remains..