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.
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.
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.