SQL2K Linked Svr Login Impersonation

Hi,

Does anyone know how to get SQL 2000 linked servers to impersonate Active
Directory logins?

Our developers need to write stored procedures that call remote stored
procedures. In production, the procs will run under SQL Server logins, so
it is easy to set up that impersionation. But the developers can't create
the procedures becuase the local server can't use the developer's AD login
to get to the remote server. I don't want to have to set up a bunch of SQL
logins to map developers's local logins to on the remote server. What a
friggin' pain!

--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org


.

Relevant Pages

  • SQL 2005 Express Connection Problem
    ... The remote site is not a company ... this remote site and try to log in I get this error: ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: object level permissions being lost when migrating
    ... Just want to confirm that you are talking about SQL Logins and not windows Logins correct? ... As far as I know the compatibility level should not be an issue one way or the other but exactly how are you looking at the permissions? ... I first transferred the logins from the 2000 server to the 2005 server via ...
    (microsoft.public.sqlserver.security)
  • Re: Advice Needed: Asynchronous Replication/Mirroring to central o
    ... Looking for a SQL Server replication book? ... geographically-dispersed remote locations. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2005 Express Connection Problem
    ... sql2005 support auto attaching a database in the connect string. ... The remote site is not a company ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: C# - connection to a remote SQL server
    ... remove server ... want to authenticate with trusted auth or sql auth. ... storing a token for access to the remote pc. ... understand a lot about nt authentication and tokens. ...
    (microsoft.public.dotnet.languages.csharp)