January 14, 2004 at 4:50 am
Hi all,
I've recently upgraded (complete OS and SQL rebuild) 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 cluster 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
It has been suggested that I update MDAC on the SQL 7 cluster but you can't install mdac 2.6 upwards on a sql 7 CLUSTER.
Any other idea's ??
January 14, 2004 at 7:59 am
"Everything is fine apart from the fact that i get an error message
when creating a linked server from another SQL 7 cluster server to one of the
nodes in the SQL 2000 cluster."
What do you mean creating linked server to one of nodes? I assume you try to create linked server to one of the instance. The linked server name should be the virtual SQL Server name and server type is 'SQL Server' in linked server property.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply