Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Kiwi Syslog Server > Configure ODBC Data Source/Connect Kiwi to SQL server

Configure ODBC Data Source/Connect Kiwi to SQL server

Table of contents

Updated March 14, 2017

Overview

Here is the guide on how to configure the System DSN on ODBC Data Source Administrator.

Environment

Kiwi Syslog 9.4 and later

Steps

Note: This example configuration is done with Windows Server 2008.

  1. Open the ODBC Data Source Administrator > go too the System DSN tab > click Add.
  2. Select ODBC Driver for SQL Server > click Finish.
  3. Provide the information such as name, description and the IP or hostname of the SQL server > click Next.
  4. Provide the SQL server authentication details (SA account recommended) > click Next.
  5. Provide the name of the database instance from your SQL, leave the other settings in default > click Next. 
  6. Change the language or enable logging for ODBC statistics (optional) > click Finish.
  7. You can view the configuration summary and do tests to check if SQL server connection is available (click the Test Data Source button).

    This is an example result of a successful test:
  8. Click OK and it will show that the configuration is complete.
  9. Configure Kiwi Syslog to connect to the SQL server.

 

 

Last modified
17:33, 13 Mar 2017

Tags

Classifications

Public