Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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

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
15:00, 2 Oct 2017

Tags

Classifications

Public