Restoring the Kennel Connection database using Microsoft SQL Management Studio **

Restoring the Kennel Connection database using Microsoft SQL Management Studio **

Restoring the Kennel Connection database using Microsoft SQL Management Studio

If you have been advised to use SQL Management Studio to restore your KC7 backup, there is a good chance it is because there are Windows or SQL Server permissions preventing our Backup/Restore utility from functioning.  This is another solution to restoring your database but you should have your local computer professional investigate the permission issue.





Please note:  Software Connection LLC only supports Kennel Connection.  We do not, nor can we support Windows and SQL Server permission issues or any environment that is severely locked down. 



You will need to have SQL Management Studio installed on your main/server computer to complete these steps.  If you do not have it, click on Downloading and installing SQL Management Studio for instructions.



Please note:  In the steps below, the database name is TestDB.  Yours will be called wkennel7.



1.  Open SQL Management Studio.  



Windows 7 users:  Click on Start, All programs, Microsoft SQL Management Studio



Windows 8/10 users:  Click the Windows key + S key on the keyboard to search.  Search for SQL and choose SQL Management Studio.

 

2.  Choose your correct SQL instance on the login screen.  If you used the KC7 Install Wizard to install SQL Server, the instance will be called COMPUTERNAME\WKENNEL.  If the correct one is not automatically populated, you may need to click the drop down arrow and choose Browse for more.

 

 

 

3.  Once inside the Browse for Servers window, expand the database engine and look for the proper instance.  If you still don't see the proper instance, click the Network Servers tab and wait for them to populate.  Expand the Database Engine and, if the proper one appears, select it and click OK.

 

 

4.  Once you have selected the appropriate SQL instance, you now need to login.  Click in the drop down to change the Authentication to SQL Server Authentication and, if you use the KC7 Wizard to install SQL Server, use the credentials below.  If you did not use KC7 Wizard to install SQL Server, look in either your old KC6 folder for the wkennel.ini file or your KC7 folder for the wkennel.ini file and obtain the login information at the bottom in the SQL section.

 

Click the Connect button.

A computer screen with a login box AI-generated content may be incorrect.

 

 

Warning:  SQL Management Studio gives you full access to your SQL Server and your databases.  Any changes made in this program could severely impact the Kennel Connection database and the way the software is able to function.  Anything done incorrectly could cause loss of data and loss of access to the software.  Software Connection LLC does not support this software nor are we responsible for anything done inside of it.  This program should ONLY be used by a technician familiar with SQL and SQL Management Studio.  As always, be sure to backup your Kennel Connection database prior to making ANY changes in this software.



5.  Right mouse click on the Databases node and select Restore Database.

 

 

6.  Choose Device and then click the "..." browse button to the right.

 

 

7.  Click Add and then navigate to where the backup (.bak) file is located.  Choose the backup file and click OK.  Click OK again on the Select backup device screen.

 

 

8.  Click Options on the left and make sure you have the exact same options selected and then click OK to start the restore process.

 

 

You will get a successful message if the restore works.  If it fails, you will get a failure notice and a link to click either in the upper left or bottom left corner of the window.  This link will show you the error and reason why it failed.



Once the restore is complete, you can close SQL Management Studio and start Kennel Connection.

 


    • Related Articles

    • Restoring the Kennel Connection 7 database using Microsoft SQL Management Studio

      Restoring the Kennel Connection 7 database using Microsoft SQL Management Studio If you have been advised to use SQL Management Studio to restore your KC7 backup, there is a good chance it is because there are Windows or SQL Server permissions ...

    • Restoring your Kennel Connection 7 database **

      Restoring your Kennel Connection 7 database There may be times when you have to restore your database to a new computer. Important: When you restore a database, it will overwrite any data that is currently there. If you are not sure whether you have ...

    • Downloading and Installing SQL Management Studio Only

      Downloading and Installing SQL Management Studio Only, no Login Warning:  SQL Management Studio gives you full access to your SQL Server and your databases.  Any changes made in this program could severly impact the Kennel Connection database and the ...

    • Attaching SQL Database files Using SQL Server Management Studio

      Attaching SQL Database files Using SQL Server Management Studio If you do not already have SQL Management Studio installed, you'll need to install it first. Please see this guide: Downloading and Installing SSMS If you ever have a need to use SQL ...

    • Backing up your Kennel Connection database **

      Backing up your Kennel Connection database We strongly recommend that you backup your database regularly. We have supplied a Backup/Restore utility within your software to aid you in the safekeeping of your data. For KC7, the file that contains your ...
    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.
    Please view support agreement for more information