Share via

My SQL Server Services getting stopped automatically

Vishal Sharma-IT 5 Reputation points
2025-12-18T09:33:08.6266667+00:00

Dear Community,

As I have experienced that one of my client system SQL services getting stopped automatically. After rebooting the windows that service not getting started, I have to start the SQL server services manually. Can you guys please suggest me what is the exact root cause. During the investigation I just found the below error in the event viewer.

The MSSQL$WINCCPLUSMIG2014 service failed to start due to the following error:  The service did not respond to the start or control request in a timely fashion.

SQL Server | Other
Answer recommended by moderator
  1. Erland Sommarskog 133.1K Reputation points MVP Volunteer Moderator
    2025-12-19T21:22:44.3333333+00:00

    There are a number of ways to access the SQL Server errorlog:

    • It's on disk, the location could be C:\Program Files\Microsoft SQL Server\MSSQLnn.WINCCPLUSMIG2014\MSSQL\DATA\LOG. ERRORLOG is the current log, but the crash dump would be in any of the older one like ERRORLOG.1, ERRORLOG.2 etc.
    • You can run xp_readerrorlog from a query window in SSMS. With no parameters, you get the current errorlog. Specify 1 to get the most previous log and so on.
    • You can access them from Object Explorer under Management->SQL Server Logs.

    The complete crash dumps are in the LOG folder, but they are mainly of interest to a support engineer.

    If it did not start despite the server being in Delayed Start, possibly it crashed immediately, but then for some reason started successfully manually. You should be able to determine this by looking at the the starting dates for the log files.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 133.1K Reputation points MVP Volunteer Moderator
    2025-12-18T21:56:54.5066667+00:00

    I don't think changing to LocalService is a solution. And certainly not the one to try first.

    The first step is go into the Service applet and find the service and change the Startup type to Automatic (Delayed Start).

    If SQL Server stops unexpectedly, the place to check for details is the SQL Server errorlog. Usually you find a crash dump or similar.

  2. Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
    2025-12-18T11:39:21.54+00:00

    Hi Vishal,

    Thank you for reaching out to the SQL Forum.

    You can try adjusting the service logon settings through SQL Server Configuration Manager:

    1. Open SQL Server Configuration Manager.
    2. Go to SQL Server Services.
    3. Select the service you want to modify (double‑click it or right‑click → Properties).
    4. Switch to the Log On tab.
    5. If it’s currently set to This Account, change it to Built‑in account.
    6. From the dropdown, choose Local Service.
    7. Apply the changes and restart the service.

    User's image

    Hope This Helps!!

    Thanks,

    Lakshmi.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.