August 7, 2002 at 3:42 am
I am trying to set up SQL mail and have created a domain user with its own email address and changed the service to run under this user.
When I am trying to start the SQLSERVERAGENT service I am getting the following error:
Could not start the SQLSERVERAGENT service on the local computer. The service did not return an error. This could be an internal windows error or an internal service error.
Looking at the event viewer the log on is failing somewhere but the user ID and password is definately correct in the service.
Any ideas??
August 7, 2002 at 3:44 am
Just read the previous help request and it seems I am not alone.. I will read the answers to this topic first.
August 7, 2002 at 4:51 am
Check that the account you are using has the "log on as a service"local security policy setting enabled.
Hope this helps
Tim
August 7, 2002 at 7:01 am
Also, be sure the account you are starting your service has Admin rights.
Question: Have you loaded your mail client to the server yet? And what version of SQL are you working with?
Try these links, hopefully they will help you out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_3w8k.asp
http://www.microsoft.com/SQL/techinfo/tips/administration/june18.asp
And finally this one [helpful]:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q263556
Aurora
August 7, 2002 at 8:38 am
Thanks to both of you. The answer was to add the user to the sql user group and the service will then be active.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply