Access Logs

Hi all,
In our win2k3 event viewer there are hundreds of failed logon attempts
for our SQL Server. Unfortunately, this log doesn't supply any
connection specific information which is what we need. Are there any
other logs that MSSQL 2000 keeps on it's own? I want to keep a record
of these attempts just in case something does happen we maybe will have
something to go on. Thanks!
--
Regards,
TroyHi,
It will be there in SQL Server Error logs as well. The location of the files
will be in \Program files\Microsoft sql server\server name\Log directory.
or you can execute XP_READERRORLOG from query analyzer .
Thanks
Hari
MCDBA
"Troy" <poster@.designguide.com> wrote in message
news:MPG.1a9d757e7936be5a98968e@.msnews.microsoft.com...
> Hi all,
> In our win2k3 event viewer there are hundreds of failed logon attempts
> for our SQL Server. Unfortunately, this log doesn't supply any
> connection specific information which is what we need. Are there any
> other logs that MSSQL 2000 keeps on it's own? I want to keep a record
> of these attempts just in case something does happen we maybe will have
> something to go on. Thanks!
> --
> --
> Regards,
> Troy