SQL Server Performance Forum – Threads Archive

SQL Auditing

Hi Guru, I turned on the Failure option on the audit level to capture failed login attempts on my SQL 2000 cluster server. However, the failed login attempts do not write to SQL and EVENT logs. This feature works on every non-cluster server. Is this something to do with virtual note? Thanks so much,
Silaphet,

---

I don’t think there any difference between the cluster and non cluster in this case… I have clustered server and I am auditing failed login attempts and it writes to sql errorlog every time some one tries to connet with incorrect pwd… Make sure you have enabled it … exec xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’SOFTWAREMicrosoftMSSQLServerMSSQLServer’,N’AuditLevel’, REG_DWORD,2
Mohammed U.

---

True, the setting shouldn’t be working differently as compared between the installations. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

]]>