Problem solve Get help with specific problems with your technologies, process and projects.

Monitoring failed login attempts in SQL Server 2000

As failed login error reporting is disabled by default in SQL Server 2000, Security expert Steven Andres details how to enable this function.

How can I monitor SQL Server 2000 for failed login attempts? I've tried simulating a failed SA login attempt then checking the logs but nothing seems to be captured.
Sadly, failed login error reporting is disabled by default (gasp!). I don't know why Microsoft has it setup that way, but it is. Pop into SQL Enterprise Manager, choose your server, go to properties, go to the Security tab and enable it. Once this has been activated, you'll start seeing them show up in your log files. A note of caution, the errors are notoriously brief and don't provide the amount of information that I would want if I was performing forensics on the server.

Dig Deeper on SQL Server Security

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.