SQL server Agent-- Error 1053
Question
Monday, May 22, 2017 8:08 PM
Hi experts
Getting the below error when restarting SQL server Agent
Windows could not start the SQL server Agent(MSSQLSERVER) service on Local computer
Error 1053. The service did not respond to the start or control request in a timely fashion.
Experts guide me how to troubleshoot.
All replies (6)
Tuesday, May 23, 2017 3:22 AM âś…Answered
Hello,
Please open SQL Server Configuration Manager and update the password of the service account used to start SQL Server Agent service.
You can also try to add the mydomain\myuser as login on the SQL Server instance and provide permissions for the login on the MDC database.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
Monday, May 22, 2017 8:32 PM
Hello,
Please open with notepad the SQLAGENT.OUT, there you will find more information.
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log
The following article may help you resolve this issue:
https://support.microsoft.com/en-us/help/322140/error-1053-when-you-try-to-start-sql-server-agent
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
Monday, May 22, 2017 9:13 PM
[298] SQLServer Error: 4060, Cannot open database "MDC" requested by the login. The login failed. [SQLSTATE 42000]
Monday, May 22, 2017 9:16 PM
i have already done with the Microsoft article but no luck and the service account which i am using has no issues at all
Wednesday, May 24, 2017 7:45 AM
i am trying to configure SQL server Agent(MSSQLSERVER) with other service account but still the service does not start. wen i checked the log it is still trying to point the old service account. How do i point to the new service account.. experts i am not sql admin so plz guide me
Thursday, May 25, 2017 5:23 AM
Hi
Server Agent service doesnot start after the change the pwd in SQL Server Configuration Manager.
Experts any other steps to resolve this