Linked Server Logins

• Adam Campbell

  SSC Eights!

  Points: 982

  More actions

  January 9, 2007 at 9:15 am

  #62789

  Is it possible to map a SQL login as the local login and have it use a windows login as the remote login?  I can't seem to get it to work.  I have a SQL login I use for my web apps to get information, but we just moved a linked server to Windows 2003 Server and now certain processes won't run unless the user is the domain admin.  I run some of these processes from the web apps via xp_cmdshell, but since they are not connecting to the linked server via the administrator, it is failing.  How can I link sql login with a domain windows login as the remote (just for now so we can get things working)?

  Thanks,

  Adam

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 9, 2007 at 12:53 pm

  #682160

  I did not understand your question completely but....

  If you want to map the login to run the xp_cmdshell on the remote server you can map it to 'sa'... I don't think you can map it WIDOWS login...

  Becareful when you are using xp_cmdshell thourgh app...

   

  Check the following two articles...

  http://support.microsoft.com/kb/555017

  http://support.microsoft.com/?kbid=834849

  MohammedU
  Microsoft SQL Server MVP