Re: Linked SQL Servers
From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 12/30/02
- Next message: Shaun Stuart: "Can't delete login"
- Previous message: John Bell: "Re: Executing dynamic select statement in a SP"
- In reply to: Brian: "Linked SQL Servers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Jasper Smith" <jasper_smith9@hotmail.com> Date: Mon, 30 Dec 2002 15:16:55 -0000
You need to provide a security context for the 2000 server
to use when connecting to the SQL7 box. Have a look at the
security tab of the linked server properties in EM and also the
sp_addlinkedsrvlogin command in BOL. Basically you need to
map the login you are using in EM or in your procedures/jobs
to a login on the SQL 7 server.
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Brian" <bdavis@insurance.state.al.us> wrote in message news:06a501c2b010$586f7520$d3f82ecf@TK2MSFTNGXA10... > I've posted this question before, but haven't had much > luck in getting an answer to it. > > I have two SQL Servers located on separate devices > (within the same room). One is SQL Server 2000, the other > is SQL Server 7.0. > > Using EM from the 2000 server, I've added the 7.0 server > as a linked server (I've also used sp_AddLinkedServer to > do this). We are using Windows authentication. > > When I execute sp_LinkedServers from the 2000 Query > Analyzer, the 7.0 server is returned in the result set as > being linked to the 2000 server. > > However, when (either using 2000 EM or attempting to > execute queries against tables in the 7.0 server from the > 2000 server), I receive an error message that reads > approximately as follows: "Login failed. Reason: User > Administrator not associated with a trusted SQL Server > connection." > > In that I can "ping" the 7.0 server from the 2000 server, > I know that the 2000 server "sees" the 7.0 server. > > Any assistance as to what the problem might be will be > greatly appreciated. > > Thanks. > > Brian
- Next message: Shaun Stuart: "Can't delete login"
- Previous message: John Bell: "Re: Executing dynamic select statement in a SP"
- In reply to: Brian: "Linked SQL Servers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
