locked
SQL Server Security Auditing Purpose RRS feed

  • Question

  • How to enable Secuirty auditing for SQL server which can help to check history of users who has logged in  SQl Server.
    Tuesday, November 6, 2012 1:47 AM

Answers

All replies

  • Hi,

    You don't mention a version however this is a good run down on auditing - http://www.simple-talk.com/sql/database-administration/sql-server-audit-magic-without-a-wizard/


    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    Tuesday, November 6, 2012 2:25 AM
  • Version is SQL Server 2005 and SQL Server 2008 both.

    Tuesday, November 6, 2012 3:03 AM
  • I have followed your provided link for SQL Server 2008 ..When I fill all the audit details n clicked on ok button..error occur and its showing auditing not available in this edition of sql server.The verison of SQL server is sql server 2008(10.50.2500). Please help me to resolve this.

    Please provide details for SQL server 2005 and sql server 2000 also.

    Thanks

    Tuesday, November 6, 2012 4:07 AM
  • Database Audit requires 2008, and EE (in 2012 pers are available in lower editions). Statistics about who logged in when is available without any fancy auditing functionslity, just tight-click the server in SSMS, Properties, Security and there you have your login auditing.

    Tibor Karaszi, SQL Server MVP | web | blog

    Tuesday, November 6, 2012 8:42 AM
  • Note that the SQL Server errorlogs will be flooded with login success messages if you enable it from SSMS - server properties

    Tuesday, November 6, 2012 11:44 AM
  • create a server side profiler trace to capture login details of each user. You can save it into .trc files & can use it for further purpose. This will work in both SQL 2005 & 2008.

    Refer Link : http://sqlserverpedia.com/blog/sql-server-bloggers/how-to-create-a-server-side-trace-with-sql-profiler/


    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.


    • Edited by RohitGarg Tuesday, November 6, 2012 12:37 PM
    • Marked as answer by Nikhilsharma01 Thursday, November 8, 2012 6:07 AM
    Tuesday, November 6, 2012 12:36 PM
  • IF all you want is a log of successful (and unsuccessful) login attempts to an SQL Server Instance, then you can view the Security log in Event Viewer.

    http://technet.microsoft.com/en-us/library/cc775525(v=ws.10).aspx

    Wednesday, November 7, 2012 7:07 PM