SQL Server - automatic service start

Forums › Microsoft Windows › SQL Server - automatic service start

StevieT

706 posts

Ultimate Geek
+1 received by user: 34

#295552 6-Apr-2022 09:19

Hi there

I have SQL Server Express installed on Windows 11, to run Galaxy (https://www.uts.com/Products/Galaxy).

All seems good in Services - it is set to automatic as startup type. Whenever I shut down and start up my laptop the next day, the service will start/run automatically.

However, I notice *sometimes* when I restart my laptop (eg an update), the service won't automatically start up and I need to do this manually. This is after giving my laptop an hour to load everything it needs to, before I encounter an error when opening Galaxy.

Anyone with ideas on how to make SQLSERVER start/run automatically everytime I restart?

Many thanks

Stevie

nzkc

1634 posts

Uber Geek
+1 received by user: 1041

#2897459 6-Apr-2022 09:23

Its probably starting, or trying to start, but failing for some reason. You can check its logs in Event Viewer or the Errorlog file (there are some numbered ones as it cycles them with each restart....and more often if you configure that) for why.

It may be its attempting to start before you network stack is up and that is failing it. You can set it to Automatic (Delayed Start) if you like. That might help it.

SepticSceptic

2263 posts

Uber Geek
+1 received by user: 779

Trusted

#2897852 6-Apr-2022 22:32

Maybe a dependency?
Ie. Something else needs to successfully start before sql starts.

Dependencies should be in the properties section of the sql service.

bagheera

544 posts

Ultimate Geek
+1 received by user: 189

#2897907 7-Apr-2022 08:29

when you shutdown, you not shutting down in windows 10 / 11 in default setting, you are doing a mini hibernating and not clearing the memory - you need to turn off fast start to shutdown a pc. A restart unloads everything from memory and needs to be reloaded, and whatever it needed most likely not load, or it takes too long to start with everything else loading, as people say, set to automatic delay start and it should fix this.

StevieT

706 posts

Ultimate Geek
+1 received by user: 34

#2898703 8-Apr-2022 17:34

Thanks for the suggestions. I have modified the service to 'Automatic (Delayed Start)' and I'll see how I get along.