Linked Server Error..
From: Brett (brett@mcpmail.com)
Date: 12/02/02
- Next message: Kalen Delaney: "Re: Login properties..."
- Previous message: Kresimir Radosevic: "Re: Login properties..."
- In reply to: Martín: "Linked Server Error.."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Brett" <brett@mcpmail.com> Date: Mon, 2 Dec 2002 08:48:50 -0800
I am selecting "SQL Server" under the "Server type" on
the "General tab".
>-----Original Message-----
>I`ve a question: what provider are you using?
>
>>-----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: Kalen Delaney: "Re: Login properties..."
- Previous message: Kresimir Radosevic: "Re: Login properties..."
- In reply to: Martín: "Linked Server Error.."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
