Changing Security Audit Option

From: Gerry (gerry03_at_nbnet.nb.ca)
Date: 08/18/03

  • Next message: Mark: "dbo association" 
    Date: Mon, 18 Aug 2003 09:29:51 -0700

    I currently have an SQLServer database server with
    Auditing set to ALL. It's a web-enabled database, and is
    getting hits every few seconds. I'd like to change the
    setting to FAILURE to just get failed attempts (so I can
    tell if someone is trying to get in other than through the
    web application).
     
    Do I have to restart the server when changing settings?
     
    I know the BOL states "you must stop and restart the
    server for auditing to be enabled", but auditing is
    already enabled, I just want to change the level,
    preferably without an outage.
     

  • Next message: Mark: "dbo association"

    Relevant Pages

    • Re: Changing Security Audit Option
      ... Jasper Smith (SQL Server MVP) ... Auditing set to ALL. ... Do I have to restart the server when changing settings? ...
      (microsoft.public.sqlserver.security)
    • Re: Changing Security Audit Option
      ... >Auditing set to ALL. ... >Do I have to restart the server when changing settings? ...
      (microsoft.public.sqlserver.security)
    • Re: Auditing object access from network
      ... server with domain member clients accessing the target file structure via ... I want to audit file deletions in specific directories of a file server, ... NOT BY USERS ACCESSING FILES VIA THE NETWORK. ... Set up auditing ACLs for every entity in Active Directory, ...
      (microsoft.public.win2000.security)
    • RE: filenames changing
      ... Mal is right, let's turn on file auditing, and troll the security log ... the server resides, right-click on it and click Properties. ... On the Group Policy tab, select a GPO and click Edit (if there's no GPO ... Microsoft CSS Online Newsgroup Support ...
      (microsoft.public.windows.server.sbs)
    • SBS2K Server, how to change local policy, auditing on. Make Effective Setting.
      ... I ran Microsoft's MBSA 1.2.1 and noticed that auditing was not on on one ... I turned auditing on for the domain on the server, ... Effective Setting set is "Audit Account Management." ... Was I supposed to instead of editing the default domain policy in Active ...
      (microsoft.public.backoffice.smallbiz2000)
    • Quantcast