##### # # Copyright (C) 2003 G Ramon Gomez <gene at gomezbrothers dot com> # Tyco Fire and Security GTS (www.tycofireandsecurity.com) # All Rights Reserved # # This file is part of the Prelude-LML program. # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2, or (at your option) # any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; see the file COPYING. If not, write to # the Free Software Foundation, 675 Mass Ave, Cambridge, MA 02139, USA. # ##### ##### # # The rules included here were developed using Microsoft SQL Server 2000 SP3a # events collected using NTSysLog. Please report any inconsistencies on other # versions to G Ramon Gomez at the address provided above # ##### #LOG:Nov 24 14:45:58 testdb.itg.sac.tfs mssqlserver[info] 17055 18456 : Login failed for user 'probe'. regex=(mssql.+)\[\w+\] \d+ \d+ : Login failed for user '(?!sa)(.+)'; \ classification.text=Database user login; \ id=1000; \ revision=2; \ analyzer(0).name=SQL Server; \ analyzer(0).manufacturer=Microsoft; \ analyzer(0).class=Database; \ assessment.impact.severity=medium; \ assessment.impact.completion=failed; \ assessment.impact.type=user; \ assessment.impact.description=An attempt was made to login to MS-SQL instance $1 using account $2; \ target(0).user.user_id(0).type=target-user; \ target(0).user.user_id(0).name=$2; \ target(0).process.name=$1; \ last #LOG:Nov 24 14:45:58 testdb.itg.sac.tfs mssqlserver[info] 17055 18456 : Login failed for user 'sa'. regex=(mssql.+)\[\w+\] \d+ \d+ : Login failed for user 'sa'; \ classification.text=Database admin login; \ id=1001; \ revision=2; \ analyzer(0).name=SQL Server; \ analyzer(0).manufacturer=Microsoft; \ analyzer(0).class=Database; \ assessment.impact.severity=medium; \ assessment.impact.completion=failed; \ assessment.impact.type=admin; \ assessment.impact.description=An attempt was made to login to MS-SQL instance $1 as sa; \ target(0).user.user_id(0).type=target-user; \ target(0).user.user_id(0).name=sa; \ target(0).process.name=$1; \ last