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

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...

    • Adding SQL Server Exceptions to Windows Firewall

      Adding SQL Server Exceptions to Windows Firewall Adding SQL Server exceptions to Windows Firewall In order to allow workstations to connect to SQL Server on your main/server computer, Windows Firewall exceptions will need to be added.  Complete the ...
    After-Hours Emergency Support
    For use ONLY outside of business hours. (Mon-Fri, 8am to 7pm ET). 

    To avoid any delay, be sure to search this knowledgebase for your issue prior to submitting a ticket. Most answers can be found here.

    If you're issue does NOT consist of one of the following, please email support@kennelconnection.com with your issue to create a ticket and someone will get back to you on the next business day. 

    - Kennel Connection Desktop - Will not open on any machine including server. 
    - KC-Cloud - Cannot login/spinning and you've verified you have Internet.
    - KC Online Reservations - Clients are getting an error upon login or cannot book ANY reservations.
    - Hello-Groom - Cannot login/spinning and you've verified you have Internet.
    - Credit Card Processing - Cannot take payments at all from any method.
    - PawLoyalty - Cannot login/spinning or extreme latency and you've verified you have Internet.

    *Utilizing the emergency support for non-emergencies will not receive a call back.
    *Users without a valid subscription will not receive a call back and will need to speak with a sales representative on the next business day.