Wednesday, March 21, 2012

Help! Linked Server between 6.5 and 2000 error

Hi
I have 2 servers: Server A: SQL 6.5 and Server B: SQL 2000.
on Server A, I added Server B as a remote server and added a remote login
(trust) from Server B via Enterprise Manager.
on Server B, I added Server A as a linked server and add remote login (the
same login as server A and password) via Enterprise manager.
On Server B, I can make RPC on Server A. But on Server A, when I do the
following: serverB.mydb.dbo.sp_helpuser, I got error: Error:18483 at Line:0
Message:Could not connect to server 'ServerB' because 'mylogin' is not
defined as a remote login at the server.
What is the problem here? I actually already have sa have the same setting
between A and B. It works both ways. Why the one I just added does not wor
k?
Need help!
Julia> Hi
> I have 2 servers: Server A: SQL 6.5 and Server B: SQL 2000.
> on Server A, I added Server B as a remote server and added a remote login
> (trust) from Server B via Enterprise Manager.
> on Server B, I added Server A as a linked server and add remote login
(the
> same login as server A and password) via Enterprise manager.
> On Server B, I can make RPC on Server A. But on Server A, when I do the
> following: serverB.mydb.dbo.sp_helpuser, I got error: Error:18483 at
Line:0
> Message:Could not connect to server 'ServerB' because 'mylogin' is not
> defined as a remote login at the server.
> What is the problem here? I actually already have sa have the same
setting
> between A and B. It works both ways. Why the one I just added does not
work?
> Need help!
> Julia
--
SQL 6.5 connecting to SQL 2000 won't work. SQL 2000 did not exist when SQL
6.5 was designed. Hence, SQL 6.5 does not support SQL Server 2000 as a
remote server.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment