Audit level output

Hi,
I am testing the Audit Level for login attempts for a
SQL Server 2K and 6.5. On the help I found that the output
can record on Windows application log, SQL Server error
log or both, it "depending on how I configure logging for
the instance"
Do you know how I can configure the "logging for the
instance"? I want to see the outputs for both SQLserver
versions and choice only one output.
ThanksHi,
Do you know how I can configure the "logging for the instance"?
SQL 2000 - Open enterprise manager -- Right click on server and select
properties and then choose the Security tab and select Audit level "ALL"
and click Ok
and restart SQL server service.
SQL 6.5 - Open Enterprise manager of SQL 6.5- Right click above the server
and choose Configure - Select Security options Tab -- In Audit level
Check both Successfull and Failed Logins and click OK and restart SQL Server
service.
Thanks
Hari
MCDBA
"Miriam" <anonymous@.discussions.microsoft.com> wrote in message
news:f65301c4112f$9dfe4b80$a601280a@.phx.gbl...
> Hi,
> I am testing the Audit Level for login attempts for a
> SQL Server 2K and 6.5. On the help I found that the output
> can record on Windows application log, SQL Server error
> log or both, it "depending on how I configure logging for
> the instance"
> Do you know how I can configure the "logging for the
> instance"? I want to see the outputs for both SQLserver
> versions and choice only one output.
> Thanks
>|||You can affect the logging to the application event log with
different startup settings. Logging to the event log is
enabled by default. Using the startup option -n will disable
logging to the event log. There is a little more info about
this in books online under Startup options.
-Sue
On Tue, 23 Mar 2004 15:36:08 -0800, "Miriam"
<anonymous@.discussions.microsoft.com> wrote:

>Hi,
> I am testing the Audit Level for login attempts for a
>SQL Server 2K and 6.5. On the help I found that the output
>can record on Windows application log, SQL Server error
>log or both, it "depending on how I configure logging for
>the instance"
>Do you know how I can configure the "logging for the
>instance"? I want to see the outputs for both SQLserver
>versions and choice only one output.
>Thanks