RE: SQL logins logged where

From: Kevin McDonnell [MS] (
Date: 01/03/03

From: (Kevin McDonnell [MS])
Date: Fri, 03 Jan 2003 21:47:27 GMT

Enable SQL Server auditing for successfull and failed logins.
Right click on the server in Enterprise Manager, Properties, Security Tab,
Select audit for successfull & failed logins (All).
Restart SQL Server.
Review the NT Application Event log and/or SQL Server Errorlog.
Setup a machine to run profiler & dump the results to a table. Add the
security event under Security Audit for Login Failed.
Review your audit tables as needed.


Kevin McDonnell
Microsoft SQL Server

This posting is provided AS IS with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit

Relevant Pages

  • Re: Security Reporting
    ... The ultimate SQL Server 2000 security guides. ... To enable auditing of failed connections with Enterprise Manager in SQL ... On the Security tab, under Audit Level, click Failure. ...
  • Re: Security audit
    ... my database security for holes. ... >can be used to create a C2 audit... ... >And the SQL Server 2000 C2 Administrator's and User's ... >> like this or know of a place that would help in writing ...
  • auditing database/server activities
    ... with increased concern of security these days. ... audit the activities on a sql server database? ... if they use in the box tools, is the audit trail managable? ... are people using a 3rd party tool to do sql server auditing? ...
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...