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 > Administrative Tools > Data Sources (ODBC) >
System DSN tab > Add > SQL Server.
Name : wkennel6
Description: Kennel Connection
Server: Click drop down and choose your SQL server.
Click Next. You can set login to use either Windows NT authentication or using SQL server authentication. We recommend using SQL Server authentication. The username and password will be what you created for the SQL server. If you do not know the password, open the KC6 folder and find the wkennel.ini configuration file. Open it. At the very bottom will be the PID which is the password.
Login ID: sa
PW: SQL PW
Click Next. You will now need to change the “default database” to “wkennel”. Click the dropdown and choose “wkennel”. 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.