Windows Forum
Other than running a trace to audit logins using the Profiler, is there another way to audit logins within SQL Server that would be similiar to the Security Event Log within Windows 2000?
Thank You
by joseph moore
Well, not with SQL Server itself. From the SQL Books Online:
"Microsoft? SQL Server? 2000 provides auditing as a way to trace and record activity that has happened on each instance of SQL Server (for example, successful and failed logins). SQL Server 2000 also provides an interface, SQL Profiler, for managing audit records. Auditing can only be enabled or modified by members of the sysadmin fixed security role, and every modification of an audit is an auditable event."
Basically, using Profiler is the recommended way to check to see who is logged onto a SQL server, or who failed to logon.
Now, a 3rd party tool I really liked is from Quest Software. A link to their SQL Server product is here:
http://www.quest.com/solutions/sql_server.asp
It checks out the SQL Server and displays all kinds of statistics. I do believe it displays user logons, and probably failed logons. There were all kinds of reporting options available with it. I ran the demo and loved it, but I couldn't justify to management to buy it! :-(
Anyway, try that out to see if it works for you.
hope this helps
This discussion is closed to new replies.
Sort by Trending