SQLServerAgent could not be started (reason: Error creating a new session)

07 May,2013 by Jack Vamvas

 After a Windows Patch upgrade on a  server with SQL Server 2005 installed , start up error messages appeared on start up of some SQL Server Services.

 

SQLServerAgent could not be started (reason: Error creating a new session).

 

This was strange , as there were three SQLServer Agent services on this server – all using the same service account username and password. Two started OK. But the third generated the error message

 

 After some trial and error , I decided to complete the following steps , which fixed the problem :

 

1) Switched the account in windows services to a local system account.

2) Started SQL Agent  - OK

3) Stopped SQL Agent - OK

4) Changed the service account back to the service account in windows services

5) Started Agent. - OK

 

A strange error and I still haven’t understood the root cause. I assumed it would be changes in permissions on the SQL Agent security context and I did look at the account . The account was under the correct group with the correct privileges.

I also used this technique to Find who made a database security change - SQL Server DBA

If anyone has experienced similar problems, let me know  - either contact me or leave a comment

 

Read More on managing SQL Server security

Powershell sql server security audit - SQL Server DBA

SQL Server Security Policy - SQL Server DBA

Security Risk Analysis and database security - SQL Server DBA


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQLServerAgent could not be started (reason: Error creating a new session)


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer