Re: How to create SQL Login audit log?

From: kai (kailiang_at_earthlink.net)
Date: 07/20/05 

Date: Wed, 20 Jul 2005 14:00:12 GMT

Guo,
 Thanks for your help.
  I setup "All" for Audit level in security, after that, in application
view, I restart SQL Server, I found user colum is "N/A" or "System". Any
thing I did not do?

Thanks

Kai

"Sophie Guo [MSFT]" <v-sguo@online.microsoft.com> wrote in message
news:15x7bmQjFHA.588@TK2MSFTNGXA01.phx.gbl...
> Hello,
>
> SQL Profiler is a component of SQL Client Tools. Check if you have
> installed SQL Client Tools on your server. By default, you can start SQL
> Profiler by clicking Start > All Programs > Microsoft SQL Server >
> Profiler.
>
> To audit on successful login attempts or failed login attempts, you need
> to
> select the option "Audit level: success" or "Audit level: failure" or
> "Audit level: All" in the SQL Server Properties (Security Tab). You can
> refer to the following information in the "SQL Server Properties (Security
> Tab)" topic in SQL server Books Online(BOL):
>
> ----------------------------------
> All
>
> Audit on both successful and failed login attempts. You can record
> attempted user accesses as well as other SQL Server log information, and
> enable auditing for both security modes, and you can record information on
> both trusted and nontrusted connections. Log records for these events
> appear in the Windows application log, the SQL Server error log, or both,
> depending on how you configure logging for your SQL Server.
>
> If you select this option, you must stop and restart the server to enable
> auditing.
> ----------------------------------
>
> For more information, refer to the "SQL Server Properties (Security Tab)"
> topic in BOL.
>
> I hope the information is helpful.
>
> Sophie Guo
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
>
>

Relevant Pages

  • Re: One Web Service updates SQL, another cant?
    ... In the profiler, in the Events tab, click on Security Audit. ... Columnist, SQL Server Professional ... And then I start getting the database closed errors on subsequent calls. ... >>> thing to look at is the permissions for that user in EM. ...
    (microsoft.public.sqlserver.security)
  • Re: file backup component
    ... Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. ... file backup app or any other app that need LDF file a while. ... he meant something that belongs to the SQL server itself. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Audit logging an adp
    ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Multiple Instances - Properties tuning
    ... Why do you want to install mutiple instances of SQL Server since you have ... memory usage for each instance of SQL Server. ... would you yourself choose to audit All or None? ... > If I were to audit, would I benefit from only auditing failure, or ...
    (microsoft.public.sqlserver.server)
  • RE: Multiple Instances - Properties tuning
    ... Why do you want to install mutiple instances of SQL Server since you have only 1 GB of physical ... memory usage for each instance of SQL Server. ... would you yourself choose to audit All or None? ... > If I were to audit, would I benefit from only auditing failure, or ...
    (microsoft.public.sqlserver.server)