RE: Cross Server Windows Authentication

From: Rand Boyd [MS] (rboyd_at_onlinemicrosoft.com)
Date: 11/20/03 

Date: Thu, 20 Nov 2003 18:21:17 GMT

Sounds like you are running into a double hop situation. This is only
supported in SQL Server 2000 if you are using Kerberos. As Sue indicated,
if you are not you will have to change the security mapping of your linked
server to a SQL Server login on the remote machine.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: SPN Requirement
    ... Making SQLSrvRunas member of Domain Admin and restarting SQL Server - ... As Sue point out, making the SQL Service account member of the domain ... The SQL Server service account should not be ...
    (microsoft.public.sqlserver.security)
  • Re: SPN Requirement
    ... Thank you Sue for translating the Error code (I?ll better find out how to ... Making SQLSrvRunas member of Domain Admin and restarting SQL Server - ... making the SQL Service account member of the domain ... ?Run the SQL Server service using a least privileged account to minimize the ...
    (microsoft.public.sqlserver.security)
  • Re: linked server from sql 2000 to sql 2005
    ... Thanks for your interest, Sue. ... Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" ... install de SQL Server 2005 Native Client in the SQL 2000 box? ... Check 2000 BOL for the topic: Security Account Delegation ...
    (microsoft.public.sqlserver.security)
  • Re: Resticting data access
    ... It now certainly seems to be an issue with the ADP file, ... > SQL Server Profiler comes with SQL Server client tools. ... >>Thanks Sue. ...
    (microsoft.public.sqlserver.security)
  • very very urgent
    ... I have been searching how to find the way to get data from sql server and put ... it the exchange server public folders, Sue already told me no direct tool to ...
    (microsoft.public.outlook.program_vba)