Linked SQL Servers
From: Brian (bdavis@insurance.state.al.us)
Date: 12/30/02
- Next message: John Bell: "Re: Executing dynamic select statement in a SP"
- Previous message: Dan Guzman: "Re: Executing dynamic select statement in a SP"
- Next in thread: Jasper Smith: "Re: Linked SQL Servers"
- Reply: Jasper Smith: "Re: Linked SQL Servers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Brian" <bdavis@insurance.state.al.us> Date: Mon, 30 Dec 2002 06:32:56 -0800
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: John Bell: "Re: Executing dynamic select statement in a SP"
- Previous message: Dan Guzman: "Re: Executing dynamic select statement in a SP"
- Next in thread: Jasper Smith: "Re: Linked SQL Servers"
- Reply: Jasper Smith: "Re: Linked SQL Servers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
