Linked Server problem...
From: Brett (brett.davis@wedbush.com)
Date: 02/03/03
- Next message: Vinod: "Re: MS Desktop Engine 2000"
- Previous message: SQL Server Development Team [MSFT]: "Re: AUTHENTICATION TO APPLY SP3"
- Next in thread: Girish Chander [MS]: "Re: Linked Server problem..."
- Reply: Girish Chander [MS]: "Re: Linked Server problem..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Brett" <brett.davis@wedbush.com> Date: Mon, 3 Feb 2003 10:56:14 -0800
Hello
I am attempting to connect to a remote Windows 2000 \SQL
Server 2000 server from another Windows 2000 \ SQL Server
2000 server. In the security tab in the properties window
for the linked server I am using "Be made using the
login's current security context".
When I open Query Analyzer and I choose to connect to the
database server with Windows Authentication and I attempt
to run a remote query. I get the following error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Any ideas as to the problem and the solution or work
around?
Please advise...
Best Regards,
Brett Davis MCP
- Next message: Vinod: "Re: MS Desktop Engine 2000"
- Previous message: SQL Server Development Team [MSFT]: "Re: AUTHENTICATION TO APPLY SP3"
- Next in thread: Girish Chander [MS]: "Re: Linked Server problem..."
- Reply: Girish Chander [MS]: "Re: Linked Server problem..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|