June 19, 2007 at 10:58 am
I'm having trouble debugging an issue. Over the weekend I had all my SQL IDs disabled at the same time. The NT Logins were not affected. I can't seem to find anything in the SQL Error logs or the server's logs. Any suggestions about where to look to find some history or auditing?
Thanks in advance.
June 21, 2007 at 2:04 am
Is your authentication mechanism changed from Mixed Mode to Windows mode check that. You will not be able to login with sql ids if your server is running under windows mode authentication.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 21, 2007 at 4:45 am
Thanks - no, the server is in Mixed Mode. What I want to know is a way to find out Who, When, Where this happened - any type of audit trail; any system tables I can query.
The server is SQL Server 2005 Enterprise, SP1.
July 3, 2007 at 1:27 am
You can find when the cahnge has happened by querying the syslogins and looking for modified date. Who has performed this can't be tracked unless you have profiler or other audit tools running.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply