Re: Tracing sql server user logins

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka@reproms.si)
Date: 07/31/02 

From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si>
Date: Wed, 31 Jul 2002 14:46:03 +0200

Neil,

You have to start auditing, SQL Server does not audit by default. Base login
auditing can be turned on with procedure:
Right-click a server, and then click Properties.
Under Audit level, select the level at which user accesses to Microsoft® SQL
Server™ are recorded in the SQL Server error log:
None causes no auditing to be performed.
Success causes only successful login attempts to be audited.
Failure causes only failed login attempts to be audited.
All causes successful and failed login attempts to be audited.
More detailed info can be gathered with the Profiler. 

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Neil Bailey" <neil.bailey@mkgeneral.nhs.uk> wrote in message
news:407001c23869$a65bc9b0$35ef2ecf@TKMSFTNGXA11...
> Does anybody know how to query SQL server (7 & 2000) to
> find the last time a user logged in.

Relevant Pages

  • Re: Whats wrong with triggers?
    ... Triggers are a detailed and legal under SOX method of auditing the data ... going in/being changed in your database, for a complete audit trail you ... there are flags that actually stop the SQL Server if the trace ... > database and the auditing system, ...
    (comp.databases)
  • 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. ...
    (microsoft.public.sqlserver.security)
  • Re: Auditing in SQL Server 2005 - Need Help
    ... Server 2000/VB6 to SQL Server 2005/VB.Net. ... meaningful audit information to the user. ... Generate audit records for all defined events, ... system resource or when auditing has been ...
    (microsoft.public.sqlserver.security)
  • SQL Server 2000 Audit for login
    ... Is there a way to audit the login on SQL Server 2000? ... way to get a report login/logout events with the name of the database. ...
    (comp.databases.ms-sqlserver)
  • RE: Audit log not logging
    ... That is what I was trying to audit. ... auditing working before the database was moved, but now I only get the error ... > starting your SQL Server service. ... >>I have a database that i need to have auditing on. ...
    (microsoft.public.sqlserver.server)