Re:Linked Server Error..
From: Vishal Parkar (vgparkar@hotmail.com)
Date: 11/27/02
- Next message: Lan Lewis-Bevan [MS]: "RE: Drive Mapping Security Problem"
- Previous message: Stamey: "Re: Difficult qualified name problem"
- In reply to: Brett: "Linked Server Error.."
- Next in thread: Martín: "Linked Server Error.."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Vishal Parkar" <vgparkar@hotmail.com> Date: Tue, 26 Nov 2002 21:37:57 -0800
Make sure remote login you are using has rights on the
objects you are selecting.
--Vishal
>-----Original Message-----
>Hello
>
>I am attempting to connect to SQL Server 2000 cluster sp2
>with the hotfix from SQL Server 7.0 server sp1 via linked
>server. I am able to make the initial connection.
>However, when I attempt to view the tables I get an error
>message stating.. "Error 2: Access Denied". Under the
>Security Tab I am using "Be made using this security
>context". I have tried it under the original security
>context of my linked server user as well as 'sa'. I get
>the same error message.
>
>Thoughts anyone?
>
>Thank you,
>
>Brett Davis MCP
>.
>
- Next message: Lan Lewis-Bevan [MS]: "RE: Drive Mapping Security Problem"
- Previous message: Stamey: "Re: Difficult qualified name problem"
- In reply to: Brett: "Linked Server Error.."
- Next in thread: Martín: "Linked Server Error.."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
