Saturday, April 7, 2012

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

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

The SQL Server Agent service does not start and you get above error then then add the account under which the SQL Server agent runs to the SQL Server's sysadmin group. 

In my Laptop SQL Server Agent runs under 'NT AUTHORITY\SYSTEM', while I am doing R&D with some another issue I dropped my SQL Server 'NT AUTHORITY\SYSTEM' login and recreated and forgot to give sysadmin to this Login. After reboot of my laptop SQL Server Agent is not starting because 'NT AUTHORITY\SYSTEM' login doesn’t have a sysadmin permission. Once I had given the Sysadmin permission through right click on login and select the sysadmin permission, then the SQL Serve Agent started as normally.

This issue usually occurs when upgrading from one SQL Server edition to another edition. Check below steps for resolving this issue through step by step? 
Step1.   Open SQL Server Configuration Manager from Start menu. 
Step2.   Expand SQL Server 2008 Services. 
Step3.   Locate the SQL Server Agent service. The SQL Server Agent service is named "SQL Server Agent" for default instances and is named "SQL Server Agent (Instance name)" for named instances. 
Step4.   Right-click SQL Server Agent, and then click Properties. 
Step5.   On the Log On tab, click to select the This account check box. Specify a different account name and password. 
Step6.   In the Service status section, click Start, and then click OK.


Below error message i am getting while starting the SQL Server Agent Service.


Check below for Event viewer error.

The SQL Server Agent service does not start after you upgrade from. SQLServerAgent in 2008 could not be started. SQLServerAgent in 2005 could not be started. SQLServerAgent in 2012 could not be started. Fixing Startup Failure of SQL Server Agent Service. SQLServerAgent could not be started. SQL Server Agent Could not be Start . sqlserveragent could not be started error creating a new session. sqlserveragent could not be started reason unable to connect to server. sqlserveragent could not be started 103. sqlserveragent could not be started unable to connect to server local. sqlserveragent could not be started (reason unable to connect to server '(local)'. sqlserveragent could not be started reason. sql server sqlserveragent could not be started. error sqlserveragent could not be started. SQLSERVERAGENT service will not start.

3 comments:

I too faced same kind of issue sometime back.

Very nice one ... just one suggestion change font please

IF YOU ARE USING A USER ACCOUNT FOR THE SERVICE CHECK THIS

http://support.microsoft.com/kb/955763

Post a Comment