"CJM" <cjmwork@yahoo.co.uk> wrote in message
news:%23BvtlNJcDHA.2632@TK2MSFTNGP12.phx.gbl...
> I've just changed the account under which SQL Server starts on my
> development server. The new account has admin rights, and a corresponding
> Exchange email account - so I can now receive alerts at various points.
>
> I've restarted the server, and the SQL Server service seems to be running
> OK.
>
> However, I cant get the SQLServerAgent service running. It comes up with
the
> following error:
>
> Service Control Failure:
> An error 1069 - (The service did not start due to a logon failure) occured
> while performing this service operation on th SQLServerAgent service.
>
> To be honest, I'm not sure if the Agent service was running previously, so
> the change in account details might be a red herring.
>
> To get it working, I changed the account from a Windows account, to the
> System Account - under this setup, the Agent started fine, but then I
found
> the SQL Mail test failed.
>
> Now the SQLServer service uses the Windows Account, but the SQLServerAgent
> service uses the System Account, and... touch wood... they both appear to
be
> working...
>
> I'm just curious if my setup is correct, ie. is this a common scenario or
> should both services be under the same (Windows?) account? It seems a
little
> odd to use differing accounts.
>
> Thanks
>
> Chris
>
>
>