Linked server connection to SQL Server 2005

I have an error message of connecting to a SQL Server 2005 from SQL Server
7.0. I tried to set up a linked server connection from SQL Server 2000 and
it works fine. It not working on SQL Server 7.0. Is there a restriction of
connecting to SQL Server 2005 from 7.0? Thanks!
Error Message: Error 2: Access deniedHi
Usually this message is because there is security issue. Have you run
sp_addlinkedsrvlogin?
John
"KTN" wrote:

> I have an error message of connecting to a SQL Server 2005 from SQL Server
> 7.0. I tried to set up a linked server connection from SQL Server 2000 an
d
> it works fine. It not working on SQL Server 7.0. Is there a restriction
of
> connecting to SQL Server 2005 from 7.0? Thanks!
> Error Message: Error 2: Access denied|||I used both sp_addserver & sp_addlinkedsrvlogin. I tried these on SQL Serve
r
2000 connecting to 2005 and it works. I then used the same script on SQL
Server 7.0 and it failed. Is this something Microsoft are not supporting on
version 7.0 with 2005? Thanks!
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Usually this message is because there is security issue. Have you run
> sp_addlinkedsrvlogin?
> John
> "KTN" wrote:
>