Hi

We're trying to install DNN on a shared hosting environment with a MS SQL 2000 db for which we have a sql login with db_ddl role.

As stated in the manual we replaced databaseOwner from dbo to our ms sql uid. Our installation failes when it's trying to exexcute someting in the aspnet _... yable. For some reasons the aspnet_... tables where created with dbo as Owner, all other DNN Tables were made with our ms sql uid, which we set in web.config databaseOwner.

Upon inspection of the files listed below we found hardcoded dbo values in stead of the objectQualifier databaseOwner

installCommon.sql
installRoles.sql
installProfile.sql
installRole.sql

Is there a reason for this?

Does anyone have experience installing dnn from a non-dbo user?

We also read in the installation manual that the db_securityadmin role is needed during installation, what is the exact purpose for this? And can this role be deleted after installation? Is this role needed during upgrades as well?

Thanks

OK, sounds plausible then ;-)

Is our installation then failing because we have only the db_ddladmin role and not db_securityadmin?

Thanks