| Author |
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 denied
| |
| John Bell 2006-02-06, 9:23 am |
| Hi
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 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 denied
| |
|
| I used both sp_addserver & sp_addlinkedsrvlogin
. I tried these on SQL Server
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:
[color=darkred]
> Hi
>
> Usually this message is because there is security issue. Have you run
> sp_addlinkedsrvlogin
?
>
> John
>
> "KTN" wrote:
>
|
|
|
|