[Snort-users] snort and mssql

Stephen Shepherd StephenShepherd at ...3353...
Mon Jan 21 09:16:03 EST 2002

Yes several of us are logging to MSSQL.  You should be able to find the
binaries you need on http://www.silicondefense.com/   The setup is
similar to the MYSQL install so review that documentation.  Here are my
brief notes:

1.) Have SQL installed and running either local or on another box.

2.) Create a DB called snort on the SQL server

3.) Use the sql script mssql.conf that comes with the Win32

This is a text file with TSQL statements for creating the tables. You

run this in many different ways, but I used SQL Query analyzer tool

4.) Create a User for the snort DB and make sure it has enough rights to

add/updated the DB. I just made my snortuser DBO for the snort DB.

5.) The machine that is running Snort will need the MS SQL client

Install this by running SQL Server setup on the workstation and

the client tools install.

6.) Configure the DB plug-in line in snort.conf to point to the right DB

server and give it the appropriate credentials.

Message: 13
Date: Sat, 16 Feb 2002 22:34:46 -0800
From: Gongya Yu <yu at ...4361...>
To: snort-users at lists.sourceforge.net
Subject: [Snort-users] snort and mssql

Anyone knows if it is possible to make snort log into mssql ?

thanks !!!

More information about the Snort-users mailing list