SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Problem in enable system audit option Goto page Previous  1, 2      SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic View next topic Problem in enable system audit option Author Message abbasali Joined: 31 Mar 2008 Posts: 10 Country: United Arab Emirates I have followed the steps mentioned in the User Guide but still getting the same error mentioned earlier to you. I would very helpful if you send the steps to configure it. We waiting for your early response. Regards. Wed Apr 02, 2008 9:25 am abbasali Joined: 31 Mar 2008 Posts: 10 Country: United Arab Emirates Fail to Enable Audit I have followed the steps mentioned in the User Guide but still getting the same error mentioned earlier to you. It is specifically failing during the SQL restart step even though it has all the permission it required. It would be very helpful if you send the steps to configure it. We waiting for your early response. Regards. Wed Apr 02, 2008 9:28 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Please do not confuse installing DB Audit Management Console and installing auditing. The console can be installed anywhere as long as it can connect to the database server. The console is used to install auditing on the server and to run reports and other interactive tools. The auditing itself happens on the server. It is server-side auditing. Don't be fooled by other so called "auditing" methods. Only server side auditing is SOX compliant because only server-side auditing can capture all connections to the database whether they are network based, local shared memory based, local pipes, encrypted or unencrypted, - they all can be audited. Now, the auditing for SQL Server is part of the SQL Server instance, the process is run by the account running your SQL Server instance and with permissions of that account. As long as that account has sufficient access level to the audit repository database, you should be fine. Wed Apr 02, 2008 10:26 am abbasali Joined: 31 Mar 2008 Posts: 10 Country: United Arab Emirates Error Msg While Enabling Audit everything went fine at the end it showed this error Quote: "DBPROCESS is dead or not enabled [/quote] Thu Apr 03, 2008 5:30 am abbasali Joined: 31 Mar 2008 Posts: 10 Country: United Arab Emirates It is compatible with Clustered Environment because i am having this error. Cluster resource 'SQL Server' failed. Thu Apr 03, 2008 6:52 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 DBPROCESS is dead or not enabled - this is a result of the server restarting. When you restarted the server, console's connection to the database got terminated.. You can simply reconnect and ignore that message Thu Apr 03, 2008 10:32 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Quote: Cluster resource 'SQL Server' failed. See http://support.microsoft.com/kb/883732 This MS page explains the issue. Basically your cluster is not setup correctly. As for DB Audit, yes, it is compatible, but you must install it on both Nodes. Thu Apr 03, 2008 10:35 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours Goto page Previous  1, 2 Page 2 of 2   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.