Help! - remote server problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Julia (Julia_at_discussions.microsoft.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 08:49:02 -0800

Hi all,

I have set remote servers between Svr65 (SQL 6.5) and Svr70 (SQL 7.0). sa
is the remote login. I can run "svr65/70.dbname.dbo.sp_helpuser" on both
servers successfully.
  
But when I ran "select * from svr70.dbname.dbo.sysusers" on Svr65, I have
error:
SQL Server Error on (svr65) Error:117 at Line:1 Message:The object name
'svr70.dbname.dbo.sysusers' contains more than the maximum number of
prefixes. The maximum is 2.

when I ran "select * from svr65.dbname.dbo.sysusers" on svr70, I have error:
Server: Msg 4002, Level 14, State 1, Line 1
 Login failed

I also tried using isql to run, on svr70, I have error:
Msg 7405, Level 16, State 1, Server svr70, Line 1
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be
set for the connection. This ensures consistent query semantics. Enable these
options and then reissue your query.

Both ansi_nulls and ansi_warnings are set to ON already. Even I set when I
ran it, the same error.

on Svr65, when I using isql, I have the same error saying "Msg 117, Level
15, State 1, Svr65, Line 2 The object name 'svr70.dbname.dbo.access_level'
contains more than the maximum number of prefixes. The maximum is 2.

What is the problem here? I need it to be resolved asap.

Thanks in advance,
Julia