Re: Audit Logins - Preformance Issue??
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/28/02
- Next message: Windboy: "about Linked Servers"
- Previous message: Sue Hoegemeier: "Re: SQL Server Profiler"
- In reply to: Scott H.: "Audit Logins - Preformance Issue??"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Mon, 27 May 2002 22:24:40 -0600
Yes...at the minimum failed logins but failed and successful
to track sa logins would be best. The impact on the server
is negligible.
Don't forget to check your MSDE installations on your
network. Make sure you have the current service packs and
security updates - watch for line wrap on the links:
Make Your SQL Servers Less Vulnerable
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/tools/chklist/sqlsec.asp
Microsoft Baseline Security Analyzer
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/tools/Tools/mbsahome.asp
-Sue
On Sat, 25 May 2002 05:35:48 -0700, "Scott H."
<schenderson2@rogers.com> wrote:
>Folks,
>
>As the result of the most recent virus alert, I've been
>informed that it may be a good idea to have login auditing
>turned on for both successful, and unsuccessful logins. My
>question has 2 parts, a) Is this so, and b) does this
>impact performance whatsoever?
>On a similar note, we have ensured that our sa login does
>not have a null password and we're also blocking ports
>1433, and 1434. Is there anything else I should do to
>properly secure my SQL Server environment?
>
>Thanks in advance,
>
>Scott H.
- Next message: Windboy: "about Linked Servers"
- Previous message: Sue Hoegemeier: "Re: SQL Server Profiler"
- In reply to: Scott H.: "Audit Logins - Preformance Issue??"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
