Post subject: Database: Logon failure Posted: Jan 26, 2007 - 10:59 PM
Joined: Jan 26, 2007
Posts: 1
Status: Offline
Hello,
I just installed WinIDS for the first timea and everythings looks ok with the exception of failure to logon to the database.
I keep getting the following error in the windows Event log.
database: Failed to logon to host '127.0.0.1'
I have configured the following in the snort.conf file.
output database: log, mssql, user=snort password=test dbname=snort host=127.0.0.1 port=1433 sensor_name=WinIDS
I have validated the password many times as well.
Thanks for your advise.
ATAN
Morpheus
Post subject: RE: Database: Logon failure Posted: Jan 27, 2007 - 07:55 AM
Site Admin
Joined: Sep 04, 2003
East Coast - USA
Posts: 1462
Location: East Coast - USA
Status: Offline
Run Snort in test mode with a -T at the end of the run line.
It looks like your MSSQL database may be restricting access.
Can you login to the database using the same creditials as in the output database line in the snort.conf?
Make SURE port 1433 is open for connections. Try using telnet to access the port and see if there is a response of some kind.