Monday, October 7, 2013

SQL Server Agent Could not be started (reason: Error creating new session) - Error 15247

Recently, I was working a server which is newly built and when I tried to start the SQL Server Agent, it failed saying that the Agent service could not be started on the local computer.
When I investigate more in the event viewer i found a message which says "SQL Server Agent Could not be started (reason: Error creating new session)".

While I was checking more on this error, I found that this was a permission. I came to this conclusion when I saw the SQLAGENT.OUT file which the below messages.

Further to my investigation, I found that the Logon account of the SQL Server Agent service did not had permission on the SQL Server instance.

Resolution:
To resolve this issue, I added Logon account of the SQL Server Agent service to the SQL Server instance with sysadmin privilege.
After doing this, I was able to start the SQL Server agent.