Setting SQL to always start with Windows

Setting SQL to always start with Windows

Setting SQL to always start with Windows

When using a SQL database, SQL server needs to be running in order for Kennel Connection to function.  SQL server should always start when Windows starts.  Here are the steps.


Click on Start, All Programs.


Find Microsoft SQL Server folder.  It will list the version, for example , Microsoft SQL Server 2012.


Expand this folder by clicking on it.


Scroll down to Configuration Settings.  Expand the folder by clicking on it.


Open SQL Server Configuration Manager.


Below is how the services should be configured on your computer.  



Setting SQL server to start with Windows



To set it to start with Windows, right click on the SQL Server services line and go to Properties.


Select the Service tab.  It will look like this.



Setting SQL to start with Windows



Left click on the Start Mode and set the service to Automatic.  


SQL should now start with Windows.  If it does not start properly, you will need a local technician or SQL technician to determine what is interferring with the service during startup.


    • Related Articles

    • Setting the SQL DSN for KC6 on Windows 10

      From your desktop screen, press the Windows key  + X on your keyboard to bring up the administrative menu.  Choose "Control Panel" or use the search feature built into the task bar and search for "Control Panel". In the upper right hand corner of the ...
    • Installing Kennel Connection 7 & SQL Server

      Installing Kennel Connection 7 & SQL Server Welcome to the installation guide for Kennel Connection 7.  Kennel Connection 7 is compatible with Windows 7 or higher operating systems.  Windows 10 is recommended.  Important:  If you are installing ...
    • SQL Server 2014 Express Setup Guide

      SQL Server 2014 Express Setup Guide SQL Server 2014 Express is a free download, available from Microsoft. This article will guide you through the process of acquiring, installing and configuring SQL Server 2014 Express so that you can use it with ...
    • Windows 10 Upgrade troubleshooting guide

      Microsoft has recently begun forcing the upgrade to Windows 10 on some machines.  During this upgrade, some network, SQL server, and printing settings have been getting changed or returned to default.  In some cases, this has caused issues opening ...
    • Setting SQL Server exclusions

      Setting SQL Server exclusions When running the SQL database version of Kennel Connection, SQL and SQL Browser must be excluded from the Firewall in order for your workstations to connect.  Do the following steps. Exclude sqlservr.exe and ...