question

80499219 avatar image
0 Votes"
80499219 asked ErlandSommarskog commented

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



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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered 80499219 commented

Hi @80499219,

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.



01.jpg (70.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello, erland sommarskog and Amelia Gu MSFT

I do set up "automatic" for SQL configuration manager you said, but the first thing to turn on sqlserver is to turn on the demagnetization and start sqlserver manually

I don't know why I can't provide you with a screenshot here
Here is a brief description
This computer - Management - Windows Service - sqlserver service I also set the "automatic"
The windows system log also reports an error, which is written in this way

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

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered 80499219 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello, erland sommarskog and Amelia Gu MSFT

I do set up the "automatic" function for the SQL configuration manager you said, but the first thing to open sqlserver is to turn on demagnetization and start sqlserver manually

I don't know why I can't be here

Here is a screenshot for you. This is a brief description

This computer - manage - Windows Service - sqlserver service I also set up "automatic"

Windows system log also reported an error that was written to this

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

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ErlandSommarskog commented

Hi @80499219,

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



01.jpg (90.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Amelia,
My SQL Server won't load on startup, and times out on manual startup using SQL Server Configuration Manager. I have administrative rights and am using correct login and password. This posting looks very helpful, but when I get to creating the new DWORD value, the choices under the New prompt, including two for DWORD value, 32 bit and 64 bit are disabled. What do I do now?
Thanks, Vic

0 Votes 0 ·

It sounds like you may have a different problem. Please start a new thread, and include your story from start to end, and don't forget to inform us of which version of SQL Server you are running. I would also recommend that you check the SQL Server errorlog for information.

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered 80499219 published

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



clipboard01.jpg (34.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sorry, my English is not very good. I mean that I didn't choose "automatic (delay)" in the picture above. I set "this computer - Management - SQL Server" automatic ". Now you choose" automatic (delay) "in sql service!
Do you want to set it like this,What is the purpose of this setting
91893-%E5%BE%AE%E4%BF%A1%E6%88%AA%E5%9B%BE-20210428083656.png


0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered AmeliaGu-msft commented

Hi @80499219,
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



01.jpg (90.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OK, I see. I'll try it first

0 Votes 0 ·

Hi @80499219,
How are things going? If there's any update, please don't hesitate to let us know.
Best Regards,
Amelia

0 Votes 0 ·