Setting the SQL DSN for KC6 on Windows 10

Setting the SQL DSN for KC6 on Windows 10

From your desktop screen, press the Windows key SQL DSN on win 10 + 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".



SQL DSN on win 10



In the upper right hand corner of the Control Panel, where it says "View by", be sure it's set to "Small icons".  Then choose "Administrative Tools".



SQL DSN on win 10



Choose "ODBC Data Sources (32-bit)".  Always use the 32 bit option even if running 64 bit operating systems.



SQL DSN on win 10



Click on the "System DSN" tab.  You may see one or two already listed.  If they are for Kennel Connection and show "Microsoft Access Driver", you need to remove these before you can add one for SQL.  Click on the name and hit the Remove button.


Once there are no Access DSNs for KC listed, click "Add".



SQL DSN on win 10



Scroll to the bottom of the list and double click "SQL Server".



SQL DSN on win10



On this next screen, fill out the fields and when done, click Next.


Name:  wkennel6


Description:  can be blank or use Kennel Connection


Server:  Click the drop down arrow and choose your SQL server name.  If you don't see it and this is a workstation computer, there is a networking issue or Firewall block issue.  See steps below to add Firewall exclusions.



SQL DSN on win10



On this screen, choose 'With SQL Server authentication" option.  The username will be "sa" without the quotes and the password will be what you created for the SQL server during installation.  If you do not know the password, open the KC6 folder either locally or on the mapped drive and find the wkennel.ini configuration file.  Open it.  At the very bottom will be the PID, which is the password.  Enter the login ID and the pasword and click Next.


Login ID:  sa

PW:  SQL PW



SQL DSN on win10



If it takes longer than a few seconds to move to the next screen, you will probably receive an error message.  If the password is incorrect, it will state that in the error message.  If you see this error message:



SQL DSN on win10



It means that either you chose the wrong SQL Server name from the dropdown in the previous screen, or your Windows Firewall or third party Firewall on the server is not allowing connections to SQL.  Please note that even if Windows Firewall is disabled, sometimes it can still block this connection.  You will need to add SQL exclusions to the Firewall on the server computer by doing the following:


1.  In your Control Panel, open the Windows Firewall applet.


2.  Go to the Exceptions tab.


3.  Click Add Program.


4.  Browse to and select "C:\Program Files\Microsoft SQLServer\MSSQL.10\MSSQL\Binn\sqlservr.exe"


$.  Click OK.


6.  Click Add Program.


7.  Browse to and select "C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe".  If you have a 64 bit system, your browser may be in C:\Program Files(x86) Microsoft SQL Server\90\Shared\sqlbrowser.exe.


8.  Click OK and then click OK again.


If you are using a third party software firewall, you will need to follow their instructions to add exceptions to sqlservr.exe and sqlbrowser.exe


Restart the SQL Services or Reboot the Server.


Once you can connect, you will now need to change the default database to "wkennel".  Click the drop down and choose "wkennel" from the list.  Then press Next.


Click Finish.  Then click "Test Data Source".  This should test successfully.  If it does not, there is an issue with the connection to the SQL server.  Check firewalls.


If it tests successfully, click OK and OK again.  This will close the ODBC administrator window.  Now start Kennel Connection.


    • Related Articles

    • Setting the SQL DSN for KC6

      If running 64 bit version go to Start > and in the search field type the following: windows\syswow64\odbcad32 and then click on the link at the top of the start menu. Proceed to step 1. If running 32 bit system go to Start > Control Panel > ...
    • Setting the Access DSN for KC6 on Windows 10

      1.  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". 2.  In the upper right hand ...
    • Setting the Access DSN for KC6 on Windows 8

      To set the DSN for Kennel Connection 6 you can try this first. Open Kennel Connection and go to Utilities > ODBC > Reset DSN. If this succeeds, you should be able to print. If it fails, please proceed to the next step below. Open your Windows control ...
    • 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 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. ...