2008-03-13

How I Fixed - SQL Server Error 310

I have just spent an hour trying to work out why my Sql Server Agent would not start. I kept getting this error message
SQLServerAgent could not be started (reason: Unable to connect
to server'(local)'; SQLServerAgent cannot start).

It was making me really angry when I realised what was wrong, I did not have the account for the Windows user the agent was running under in my database to. I created an account and gave it full access to the db and now everything is going fine.

P.S. Yes I know i am an idiot.

No comments:

Post a Comment