Others: How to let the System auto start SQL Server A2006 services when Windows Start Up

From AutoCount Resource Center
Jump to navigation Jump to search

Question : My SQL Server services was always stopped after Windows update. It caused AutoCount cannot log in, and I need to manually start the Services. Is there any way to let the system auto start services when Windows start up.


Answer :

1) Go to Windows Start and search for Services.

Auto start sql1.png


2) Select the SQL Instance that you want set auto start up, such as SQL Server (A2006), then right click and select Properties.

Auto start sql2.png


3) Copy the Service name (MSSQL$A2006).

Auto start sql3.png


4) Open Notepad with Run as Administrator and type net start "service name". Example: net start "MSSQL$A2006". Save the folder in C: drive and name it as StartSQL.bat.

Auto start sql4.png


Auto start sql5.png


Auto start sql6.png


Auto start sql7.png


If your Windows user is under Administrator, follow the below steps : -

1) Open Window Run command.

Auto start sql8.png


2) Type shell:startup and click on OK.

Auto start sql9.png


3) Copy and paste the StartSQL.bat file into this folder.

Auto start sql10.png


When your computer starts up, Windows will auto pop-up this CMD, and start SQL Server (A2006) services.

Auto start sql11.png


If your Windows user is not Administrator user, follow the below steps : -

1) Go to Windows Start and search for Task Scheduler.

Auto start sql12.png


2) Click on Create Basic Task.

Auto start sql13.png


3) Key in Name as StartSQL and click on Next.

Auto start sql14.png


4) Select When the computer starts and click on Next.

Auto start sql15.png


5) Select start a program and click on Next.

Auto start sql16.png


6) Click on browse and open the StartSQL.bat file, then click on Next.

Auto start sql17.png


Auto start sql18.png


7) Click on Finish.

Auto start sql19.png


8) Click on Task Scheduler Library and double click on StartSQL.

Auto start sql20.png


9) Click on Run whether user is logged on or not and click on Change User or Group.

Auto start sql21.png


10) Click on Advanced….

Auto start sql22.png


11) Click on Find Now and select the user under Administrator and click on OK.

Auto start sql23.png


12) Click on OK.

Auto start sql24.png


13) Click on OK again and key in the Administrator password, then click on OK.

Auto start sql25.png


Auto start sql26.png


When your computer starts up, Windows will start SQL Server (A2006) services.


By : CK 181101, Lay Swan 190321, P190322


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations