sql agent will not start

[Luvsql]

We recently changed the login account that each sql server and sql agent logs in as. Both our default and instance of sql server (as well as their corresponding sql agents) are all running on the same account. Our default sql server's sql agent will no longer start (sql server service is fine as well as instance of sql and its agent is fine). THe error is"

[165] ODBC Error: 0, Cannot generate SSPI context [SQLSTATE HY000]
[000] Unable to connect to server '(local)'; SQLServerAgent cannot start

We have not changed the name of our sql server and we can connect fine with Enterprise Manager and all our apps.

 

[BuGlen]

Hi,

First, double check the login properties for the instance of agent that is causing the problems. Then, reboot the machine running the agent and allow it to try to login again.

I've had some similar issues where just retyping the login information and rebooting fixed the issue.

Hope this helps.

- Glen

Know thy data.