Hello,
In the FAQ about SQLMail, Microsoft said :
http://support.microsoft.com/default.aspx?scid=kb;en-us;311231&sd=tech
"To configure a mail profile for a service account, you must log on to
the server by using that service account."
This mean that this service account must be able to open a session on
the server, and so we need to grant the right
"SeInteractiveLogonRight", and may be that the service account be a
member of the "domain users" group...
OK, I can support giving this right only the time needed to configure
the mail profile for my account, but if then I Revoke this right, and
the service account usergroup membership, will SQLMail still work ?
Is there a way to use a secure service account with SQLMail ?
Thanks,
Geof
Sue Hoegemeier - 28 Oct 2005 15:17 GMT
You only need to grant the right to configure the mail
profile. You can remove it after that.
-Sue
>Hello,
>
[quoted text clipped - 18 lines]
>
>Geof