Error of no mapping between account names and security IDs was done

• kokyan

  SSCommitted

  Points: 1634

  More actions

  April 12, 2004 at 5:10 am

  #84871

  Dear Experts,

  I execute the extended store procedure below:

  EXEC master.dbo.xp_sqlagent_proxy_account N'SET',

               N'SQLSERVER',

               N'myID',

               N'myPassword'

  I hit an error message below:

  No mapping between account names and security IDs was done.

  How to solve this problem in order for me to add a proxy account to the server. I need to uncheck the option Only users with SysAdmin privileges can execute CmdExec and ActiveScripting job steps and provide proxy account SQL Agent login to enable non-sysadmin users to execute xp_cmdshell.

  How to determine valid domain name and user ID for the server?

  
  
  Regards,
  kokyan
  

• April 15, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734498

  More actions

  April 15, 2004 at 8:54 am

  #502960

  Hmmm, not sure. Perhaps including the domain name in the user id call? mydomain/myuser?