November 20, 2003 at 8:20 pm
Hi Guys,
Anyone can tell me how to configure the logon and user change password audit?
Thanks in advance.
November 21, 2003 at 11:09 am
Server | Properties | Security Tab. Choose login auditing level.
As far as password changes, no auditing as far as I know of.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 2:05 pm
Don't forget to restart the SQL Server service after you make the logon auditing change.
As for passwords... you'll have to build some sort of auditing methodolgy around traces or the like (or modify sp_password, though this isn't supported by Microsoft).
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
November 27, 2003 at 1:21 am
Hi,
After changing the security audit level to all. I received an error from the SQL server log.
Error: 15457, Severity: 0, State: 1
Please advise.
November 27, 2003 at 5:53 am
That error means a RECONFIGURE needs to be executed to "install" what configuration change you made. This shouldn't be related to changing the audit settings, because that's kept in a registry key. Did someone execute sp_configure or change the server properties through EM in any other way?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply