Who is the DASP database owner?

I've got OmniAudit installed on our development database and it works really well (except it can't track changes to BLOBs). However, when I try to install it on the production database (hosted on DASP), I get an error "Installing OmniView ... requires a database owner user. Reconnect as a database owner user ... to automatically install".

Is this about how the DASP database is set up (ie account owner is not database owner)? Any way aroundit if it is a DASP set up issue?

Chris

 

Were you trying to install OmniAudit or OmniView? I believe the installation is required for the OmniAudit and not Omniview .I was able to do everything (enabling audits,creating audit log tables,triggers etc) smoothly on DASP database server .Just wondering what are you trying to install with Omniview,which is basically a SQL query tool?Please correct me ,if i am wrong.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Hi Vikram.

Sorry, my mistake. I am trying to install OmniAudit and the error message excerpt should not have referred to OmniView.

The full text of the error message is:


OmniAudit has not been installed into the SQL2005_xxx database. Installing or uninstalling OmniAudit in a database requires a database owner user. Reconnect as a database owner user and select the database again to automatically install OmniAudit.

Once installed, any database owner or user belonging to the 'omniaudit_admin' database role can administrate the audit setup.
</BLOCKQUOTE>
I used the main account name (supplied by DASP) and password to connect to the database.

Does this help to clarify my problem?

Cheers,

Chris

 

Thanks. I'll try that and see how I go.