RE: Question on C2 Log
From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 10/06/04
- Next message: Tony: "Re: Login Fails after I changed Pwd for sa"
- Previous message: Prashant: "Re: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"
- In reply to: boon: "Question on C2 Log"
- Next in thread: boon: "Re: Question on C2 Log"
- Reply: boon: "Re: Question on C2 Log"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 06 Oct 2004 12:47:10 GMT
Hi Boon,
Thanks for your post.
>From your descriptions, I understood that you would like to log C2 Audit.
Have I understood you? Correct me if I was wrong.
However, I am not sure how do you define "every thing". Do you mean
auditing all logins no matter it is successfully or failed? If so, here are
four options for different audit level
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.
Take the following steps in SQL Enterprise Manager to set the appropriate
Audit Level you wanted.
1. Expand a server group.
2. Right-click a server, and then click Properties.
3. Click the Security tab.
4. Under Authentication, click SQL Server and Windows.
5. Under Audit level, select the level at which user accesses to SQL Server.
If you want to use SQL Server Profiler to auditing SQL Server activity, See
topic "Auditing SQL Server Activity" in SQL Server BooksOnline and here are
some KB on the best practise for using SQL Profiler for your reference
Support WebCast: SQL Server 2000 Profiler: What's New and How to
Effectively Use It
http://support.microsoft.com/default.aspx?scid=kb;en-us;325263
Support WebCast: How to Effectively Use SQL Server Profiler
http://support.microsoft.com/default.aspx?scid=kb;en-us;325297
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
- Next message: Tony: "Re: Login Fails after I changed Pwd for sa"
- Previous message: Prashant: "Re: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"
- In reply to: boon: "Question on C2 Log"
- Next in thread: boon: "Re: Question on C2 Log"
- Reply: boon: "Re: Question on C2 Log"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
