SQL Server (MSSqlServer) service must be started manually every time it is started

鹏 柳 96 Reputation points
2021-04-27T01:59:42.01+00:00

SQL Server (MSSqlServer) service must be started manually every time it is started. Then I set automatic startup in the service or not. 360 antivirus has not organized sqlserver to start automatically. Is there any way to enable sqlserver to start automatically

SQL Server | Other
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    2021-04-27T02:31:00.88+00:00

    Hi @鹏 柳 ,

    Is there any way to enable sqlserver to start automatically.

    Do you mean you want to set the SQL Server instance to start automatically?
    Please go to the SQL Server Configuration Manager, expand SQL Server Services and right-click the name of the instance you want to start automatically, and then click Properties.
    In the Service tab of Properties dialog box, set Start Mode to Automatic.
    91573-01.jpg
    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2021-04-27T06:48:04.517+00:00

    Your post is not very clear. If the antivirus is the problem, you will need to sort it out with Antivirus vendor - or your IT Department, if this is a corporate environment.

    But it could also be that there is a lot of things running when your machine starts. If you go to the Services applet (Control Panel->Aministrative Tools), there is one more option which is not available in SSCM: Automatic (Delayed Start). This can help to sort out the problem.


  3. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    2021-04-27T09:50:25.98+00:00

    Hi @鹏 柳 ,

    Thanks for your reply.
    It seems that the image is not displayed in your comment.

    but the first thing to turn on sqlserver is to turn on the demagnetization and start sqlserver manually.

    Sorry for my poor understanding. Do you mean you need to defragment your system disk before your starting the SQL Server service manually?

    The MSSqlServer service failed to start due to the following error: the service did not respond to a start or control request in a timely manner. Event 7000, service control manager.

    What the Service account are your using?
    If you are using domain account, please make sure the password of account is correct.

    And you can try to modify the registry to increase the default time-out value for the service control manager.
    91550-01.jpg
    Please refer to this doc which might help.
    Best Regards,
    Amelia


  4. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2021-04-27T20:58:26.167+00:00

    Just like Amelia, I don't know what you mean with "demagnetization".

    In any case, here is a screenshot from the Services applet, which shows the setting Automatic (Delayed Start):

    91881-clipboard01.jpg


  5. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    2021-04-28T06:14:26.67+00:00

    Hi @鹏 柳 ,
    SQL Server service set to Automatic will start during the boot process, while services set to start as Automatic Delayed, it will start shortly after boot. Service startup delay can avoid issues caused by conflicts between the operating system and Microsoft SQL Server. Please refer to this thread which might help.
    In addition, could you please share us the service account you are using?
    You can find it in Services-> SQL server instance properties->Log on tab.
    91925-01.jpg

    Best Regards,
    Amelia


Your answer

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