CODEWITHSUNDEEP
sqlsql-serverwindowsservicedatabase-administration
tebok
tebok

Reputation: 390

Start local server automatically

I'm using windows (10) and every time I need to use/load a database on my local server (SQL Server) I have to manually start the server on Administrator Tools (local services), which costs me a lot of time, every time I reboot my system the server shuts down (stops) and doesn't start on boot. Is there perhaps a way of automatically starting the server permanently, that could save me a lot of time. Thanks in advance.

Upvotes: 3

Views: 597

Answers (1)

Rigerta
Rigerta

Reputation: 4039

Yes, there is a way. Go to your local Services, find the SQL Server Service and set the Startup type to Automatic.

Like illustrated here:

enter image description here

Upvotes: 6

Related Questions