Wednesday, March 21, 2012

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
following.
Error 22042 xp_setsqlsecurity() returned error-
2147023564 'No mapping between account name and security
IDs was done'

Could you help to resolve this?

ThanksWhat permission/s does the new account have in sqlserver?

No comments:

Post a Comment