Results 1 to 6 of 6

Thread: Login information

  1. #1
    Join Date
    Oct 2005
    Posts
    2

    Login information

    Hi,

    Can we retrieve the Login Failed and succedded for SQL Server?

    I want to know the login failed and succedded information of SQL Server.

    Can we retrieve the same?

    Let me know ASAP.

    Thanks and Regards,
    Pramod

  2. #2
    Join Date
    Nov 2002
    Location
    cornwall
    Posts
    187
    open enterprise manager, right click on your server, on the security tab select the Audit level option that you want out of none, failure, success or all.

    FatherJack

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    The loggin information is written to error log. You can use xp_readerrorlog to read the content in a table format, then search for success or failed string.

  4. #4
    Join Date
    Oct 2005
    Posts
    2
    Thanks for the help,
    Since the current active log file is locked by SQL Server, does xp_readerrorlog file returns the current values?

    Thanks and Regards,
    Pramod.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Yes, and you can open sql server log file with any text editor.

  6. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Yes xp_readerrorlog reads current file, if you want to read older log you can pass the errorlog number

    xp_readerrorlog 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •