Tools

How to Integrate Microsoft SQL Database with Kiwi Syslog Server

This article provides steps on how to Integrate Microsoft SQL Database with Kiwi Syslog Server using the bulk insert action to log messages to a database.

First published date

5/19/2023 8:49 AM

Last published date

5/19/2023 9:37 AM

Overview

How configure the "Log to Database  -New Bulk Insert" in Kiwi Syslog Server to integrate Microsoft SQL Database (recommended).

Product section

Kiwi Syslog Server

Cause

NR

Resolution

  1. Add a Rule
    • From the Kiwi Syslog Service Manager console, choose File > Setup.
    • Add a rule, or locate an existing rule
  2. Add an Action
  3. Configure connection strings for the above action: 
    • Click "Generator" to launch the "Connection String Editor"
      • Select or Enter the name of the SQL server
      • Enter log on credentials for the database
      • Select the database (If created already). If not, contact your DB administrator to create one. 
      • Click "Test Connection" - If it shows "succeeded", click OK and save the settings. 
      • image.png
    • Could not see logs in the DB - to fix this, clicked "create new table"
  4. Database Table Name:
    • Enter a table name where you want to write the events on the database and 
    • Click "Create new table". Note: You do not need to click this option, if you have already created a table in the database. Else, you will get "..table does not exist errors".
  5. Validate the same from Microsoft SQL Management Studio or confirm it with the Database administrator.