May 18, 2014 at 11:04 pm
Hi All
I am not able to start my agent services.
1. When i tried to start from sql server configuration manager its giving error as -
The request failed or the services did not respond in timely fashion. Consult the event log or the other application error logs for details.
2. When i tried to start from services.msc its given error as -
The SQL server Agent service on Local computer started and the stoped. Some services stoped automatically if they are not in use by other services or program.
Note : On process on starting from above both way , my Sql agent is online (green colour) in ssms ,once process will complete and failed with above, agent will again off
May 18, 2014 at 11:17 pm
Can you try running services under local system account?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 2:38 am
What version and edition of SQL Server are you using? SQL Agent is not available for SQL Express Edition.
If the service account for SQL Agent set up as a login to SQL Server and does it have sysadmin rights?
Have your Windows people implemented any Group Policy Objects that limit access to services? SQL Agent needs to query the status of some services in order to complete its startup.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 20, 2014 at 11:52 am
one more bit ...
If using an AD account it needs to be in the LocalAdministrators group on the server in addition to the SQL sysadmin role.
This is especially true if the initial installation was performed using LocalSystem and then converted to an AD account to execute the SL Server services..
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
May 21, 2014 at 2:47 am
If using an AD account it needs to be in the LocalAdministrators group
This is wrong. There is no need for any SQL Server service account to be given windows administrator rights.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply