RE: How trace logon failed
From: linda deng[MS] (lideng@online.microsoft.com)
Date: 12/24/02
- Next message: Bil: "Re: xpsql.cpp"
- Previous message: Bill Cheng [MSFT]: "RE: SSPI Context"
- In reply to: MMarc: "How trace logon failed"
- Next in thread: MMarc: "Re: How trace logon failed"
- Reply: MMarc: "Re: How trace logon failed"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: lideng@online.microsoft.com (linda deng[MS]) Date: Tue, 24 Dec 2002 06:46:40 GMT
Hi,
SQL Server supports four kinds of Audit levels to record the user accesses
into the SQL Server error log files:
1. None - no auditing is performed.
2. Success - only successful login attempts are audited.
3. Failure - only failed login attempts are audited.
4. All - successful and failed login attempts are both audited.
As for tracing the IP address or the computer name of these failed logon
attempts, you can use SQL trace to monitor the information.
HTH.
Sincerely,
Linda Deng
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
- Next message: Bil: "Re: xpsql.cpp"
- Previous message: Bill Cheng [MSFT]: "RE: SSPI Context"
- In reply to: MMarc: "How trace logon failed"
- Next in thread: MMarc: "Re: How trace logon failed"
- Reply: MMarc: "Re: How trace logon failed"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
