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 Control Panel, where it says "View by", be sure it's set to "Small icons". Then choose "Administrative Tools".
Choose "ODBC Data Sources (32-bit)". Always use the 32 bit option even if running 64 bit operating systems.
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".
Scroll to the bottom of the list and double click "SQL Server".
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.
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
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:
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.