Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to connect to server in my local; SQLServerAgent cannot start Expand / Collapse
Author
Message
Posted Sunday, May 18, 2014 11:04 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 6, 2014 5:21 AM
Points: 75, Visits: 270
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
Post #1572136
Posted Sunday, May 18, 2014 11:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1572139
Posted Tuesday, May 20, 2014 2:38 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 19, 2014 6:03 AM
Points: 2,900, Visits: 3,301
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1572525
Posted Tuesday, May 20, 2014 11:52 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, December 22, 2014 11:01 AM
Points: 3,221, Visits: 2,376
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..




Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #1572824
Posted Wednesday, May 21, 2014 2:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 19, 2014 6:03 AM
Points: 2,900, Visits: 3,301
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1573036
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse