Audit level

How do I change the audit level in MSDE to all?
Hi
That is stored in the Windows Registry.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer
Value:
AuditLevel
0 = Do not log authentication attempts
1 = Log successful authentication
2 = Log failed authentication
3 = Log all authentication attempts regardless of success or failure
Regards
Mike
"Antonin Koudelka" wrote:

> How do I change the audit level in MSDE to all?
>
>
|||hi Antonin,
Antonin Koudelka wrote:
> How do I change the audit level in MSDE to all?
you have to set the following registry key to
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
AuditLevel = 3
for a named instance the key is
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
for your convenience, you can have a look at a free prj of mine, at the link
following my sign., which provides a user interface for MSDE similar to
Enterprise Manager, that features this requirement too...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Thanks for your response. It worked.
Antonin
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:38qv98F5r6d0bU1@.individual.net...
> hi Antonin,
> Antonin Koudelka wrote:
> you have to set the following registry key to
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> AuditLevel = 3
> for a named instance the key is
> HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
> for your convenience, you can have a look at a free prj of mine, at the
link
> following my sign., which provides a user interface for MSDE similar to
> Enterprise Manager, that features this requirement too...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi Mike,
Thanks for your response. It is working now (the auditing).
Antonin
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:964F6800-B416-4C39-A401-41B007B9C380@.microsoft.com...[vbcol=seagreen]
> Hi
> That is stored in the Windows Registry.
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer
> Value:
> AuditLevel
> 0 = Do not log authentication attempts
> 1 = Log successful authentication
> 2 = Log failed authentication
> 3 = Log all authentication attempts regardless of success or failure
> Regards
> Mike
> "Antonin Koudelka" wrote: