Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Question Unanswered: how to use SQL Server Agent

    I want to sendmail after finishing job by using SQl Server Agent.When I try to change SQL Server Agent start up account
    from new account in windowsxp system , I give new account a right of
    'Log oOn as a Service Right ',but I experience the error the
    Error 22042 xp_setsqlsecurity() returned error-
    2147023564 'No mapping between account name and security
    IDs was done'

    Could you help to resolve this?


  2. #2
    Join Date
    Feb 2004
    What permission/s does the new account have in sqlserver?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts