SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Facing issue while enabling System Audit with AuditDB 4.0.19

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Facing issue while enabling System Audit with AuditDB 4.0.19
Author Message
abbasali78



Joined: 08 Aug 2010
Posts: 1
Country: United Arab Emirates

Post Facing issue while enabling System Audit with AuditDB 4.0.19 Reply with quote
Hi,

We are currently using Audit DB 4.0.19 in our production environment with Microsoft Windows 2000 and SQL Server 2000.
Windows 2000 Server are not out of support so we are upgrading our production environment to Windows 2003. I am trying to redeploy DB Audit tool
to our new environment. I have copied the database to the new sql instance. The installation went fine, while enabling the Audit Service i got the following error. The SQL is under cluster environment. I have also tried to copy xp_dbaudit.dll to the bin directory but it keep giving this error. Please help we are very near to production rollout.

---------------------------
Database Processing Error
---------------------------
A database error occurred while your request was being processed. Here are the details:



Specified owner name 'db_audit' either does not exist or you do not have permission to use it.
---------------------------
OK
---------------------------
Sun Aug 08, 2010 4:50 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Copying the database is not enough, you also need to copy db_audit login, and in case you use system auditing, also copy xp_dbaudit.dll. It is important that the default database for db_audit login is set to point to the audit database and the login be correctly mapped to db_audit user in that database.

Hope this helps
Sun Aug 08, 2010 4:12 pm 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
Page 1 of 1

 
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.