C# code to start SQL Server (MySQLSERVER) Automatically

Lava Noor

please help me I created a program via C# and connect to SQL Server on the desktop/laptop when I turn off the desktop/laptop and run again the SQL Server (MYSQLSERVER) not running automatically, I want C# code to run it automatically, I appreciate someone helps me to give me C# code.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Hi,

Go start menu -> Run -> services.msc > SQL Server (MSSQLSERVER) > double click > Start up Type > Automatic.

Restart service once. Then when you start your syster next time it will work.
+2
Laxmidhar Sahoo6y ago
hi
In thar properties page the first tab is general
1-Click in general tab

2-Select Automatic option from the startup type dropdown list

3- other options as per @Gowtam described and press ok

Thanks and regards
+1
Lava Noor6y ago
Thanks, for that but the sql still not running automatic when windows start
+3
Gowtham Ramar7y ago
https://dba.stackexchange.com/questions/77659/sql-server-not-starting-at-windows-startup-but-starts-manually

follow this steps

For starting your services automatically, SQL Server needs an account with rights to start services during operating system start up.

To solve this issue you need to go Administrative Tools > Services > SQL Server(MSSQLSERVER or the name of your instances) > Right Click > Properties > Move to Log On > Set the Log On option using a Local System Account

If you have chosen this option, hit on Browse Button and find the Local Service Account or Network service Account there > Click in Apply.

Restart your computer and you will able to start your SQL Server.
+5