| This article only applies if you are using Kiwi Syslog Daemon v8.3.2 or higher. Earlier version users should click here for the information they require. Follow the steps below in order to set up Kiwi Syslog Daemon to log to a MS SQL database... Open the setup page by using the File > Setup menu option.  For the sake of this exercise we will assume that you are creating a Log to Database action in the default Rule. Right click on the Actions section and select "Add action"  Select the Log to Database action type...  Intialise the creation of the connection string by pressing the browse button...  Choose your data provider from the Provider tab. In this case we have choosen to use the SQL Native Client...  From the Connection tab specify the location of your MS SQL server. We have simply entered the IP address is this case. Once specified choose the initial database (catalog) that you wish to connect to. This article assumes that you have already created a database called kiwisyslog in your MS SQL server. You should now be able to test the connection by pressing the Test Connection button... If the test was not successful then you will need to insure that the credentials that you have specified are correct.  Assuming the test completed successfully simply click the OK button to save the connection string and return to the Kiwi Syslog Daemon Log to Database action. You will then need to insure that you have selected the correct database type/field format.  Once you have selected the Kiwi SQL format you are ready to create the table that you intend to log to...  You should see a message like the following if the table was created successfully...  If you like you can rename the new action to something more meaningful by right clicking on the action...  ... then typing the desired description...  Process complete... |
Home 
Support Knowledge Base HOW TO: Log to a MS SQL database using V8.3.2 and above
Support Knowledge Base HOW TO: Log to a MS SQL database using V8.3.2 and above
|
Loading...
 YES
 NO
|