Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kevin Snow
Posting Yak Master
149 Posts |
 Posted - 2002-04-18 : 12:16:46
|
| I have a clustered server running SQL2000On a server running 7.0, I am trying to register the clustered server as a linked server.It allows me to register, but won't retain any login mapping information.Accessing the clustered server gets me an 'ACCESS DENIED'.I've tried mapping using sa level accounts.I can register the 7.0 box on the clustered server, but not the other way.Is there any work around for this? |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-21 : 10:49:04
|
| Just an update. I can link a SQL2000 server to the cluster. Still, I cannot link a SQL 7.0 server to the same SQL 2000 cluster. I've found nothing in this forum relating to this problem. I found a reference in another forum to someone having the same difficulty, but no one could offer a solution there, either.I could not find any mention of this problem at MICROSOFT.com (And like I said, only one mention of it in another forum).I am running 7.0 SP4, and 2000 SP2 on the cluster. I set the Linked server to use a specified security context that uses SQL security only on the target server.Any suggestions? Is this WORKING for anyone? |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-21 : 11:00:13
|
are you using em to register or sp_addlinkedserver?I've heard that sometimes em is a little buggy  I don't have any direct experience here, though . . .<O> |
|
|
|
MuffinMan
Posting Yak Master
107 Posts |
Posted - 2002-05-21 : 11:04:33
|
| I encountered the same problem at my site. I can link from 2000 to 7 but not the other way around (you get the "Access Denied" even though you know you are using the correct credentials.)My guess is that it is a SQL 2000/7 architecture/MDAC issue.(Ever notice how you can't register a 2000 SQL Server using the SQL 7 Enterprise Manager?)I gave up and always set up my links from 2000 to 7. |
|
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-21 : 13:02:36
|
| I tried using sp_addlinkedserver with the same results. The closest I've been able to come from your suggestions is this:MDAC 2.6 Service Pack 1 now available for download The MDAC 2.6 SP1 (2.61.7326.6) service pack is available for download. This service pack release matches the same version of MDAC components that are installed by Microsoft SQL Server 2000 SP1. Due to issues with clustering, this release is currently NOT supported on SQL 7.0 Clustered Servers or SQL 6.5 Clustered Servers. This suggests that there may indeed be an MDAC incompatability. After checking my MDAC version (yeesh! 2.5 for the 7.0 boxes, ranging to 2.7 on the latest 2000 install) I successfully connected a 7.0 box on MDAC 2.6 to my Cluster using MDAC 2.62). Fortunately, I am not using clustering on any 7.0 servers, so I should be able to upgrade to at least MDAC 2.6 on the 7.0 boxes and get them to connect to the cluster.Thanks for the tips!!!! |
|
|
|
|
|
|
|
|
Reg. clustered server as linked server