Linked Server not logging in
- From: Randy Galliano <r_galliano@xxxxxxxxx>
- Date: Mon, 08 Oct 2007 16:32:04 -0700
Hello,
I a fairly complicated situation to explain in a newsgroup, but I am going
to give it a try:
1. I have an SQL 2005 server (call it Server A) with a database. In the
database is a view pointing that queries a table pointing to a linked
server, Server B (#2 below). The permissions are set up properly and I can
query the view from this server.
2. SQL 2005 server (Server B) with a
database that is linked to from server A.
3. Using SQL Management studio from another SQL2005 server (Server C), or
an Access database running the view Server A.
The scenario:
1. When I go to run the a query from SQL Management studio on Server C, I
get an error message saying no valid login for NT Authority\Annnomous
Logon.
2. If I go to server A and run the query, then I can come back to Server C
and the query run just fine. It will stay connected and run for a period
of time, then I get the login error again.
It almost appears as if the server where the query and linked server are
defined, is passing through the proper permissions and creating a
connection to the linked server, only if it initiates the connection.
Then it appears the connection stays open for a period of time, then it
closes.
Does this make any sense? I can replicate it every time, but still cannot
figure out why we get the login failure.
.
- Prev by Date: Re: SQL Server Connection Error
- Next by Date: Linked DB2/400
- Previous by thread: SQL Server Connection Error
- Next by thread: Linked DB2/400
- Index(es):
Relevant Pages
|
Loading
