I am currently running SQL Server 2005 Standard Edition on a Windows 2003 server machine.

I have gone to the properties of the server and confirmed that the Login Auditing is set to both failed and successful logins. For some reason though there is nothing in the logins for fails or successes in the SQL Server logs when I know there have been logins for both.

I have searched out the reason for this and have not been able to come up with anything helpful, so I am hoping that someone here could give me a little direction. This is working on my other SQL Servers, so I know where to look for the results, but there are none there.

  • I'm assuming you know logins have happened. I would do a trace to confirm they're showing up there but they probably are. Are there any errors in either the SQL or Windows logs that may be related to this? – cfradenburg Feb 27 '13 at 20:26

Per SQL Server Books Online...

Changing the audit level requires restarting the service.

Try restarting your SQL Service and then check to see if logins are being properly audited in your Error Log.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.