Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Kiwi Syslog Server > Kiwi Sys - Knowledgebase Articles > 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

This article provides guidance 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 to 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.

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

 

Last modified

Tags

Classifications

Public