SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Problem in enable system audit option
Goto page Previous  1, 2
 
Reply to topic    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

Post Reply with quote
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 View user's profile Send private message
abbasali



Joined: 31 Mar 2008
Posts: 10
Country: United Arab Emirates

Post Fail to Enable Audit Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
abbasali



Joined: 31 Mar 2008
Posts: 10
Country: United Arab Emirates

Post Error Msg Reply with quote
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 View user's profile Send private message
abbasali



Joined: 31 Mar 2008
Posts: 10
Country: United Arab Emirates

Post Reply with quote
It is compatible with Clustered Environment because i am having this error.

Cluster resource 'SQL Server' failed.
Thu Apr 03, 2008 6:52 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    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: 
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.