i am installing dnn 4.4.1 on shared hosting, they use sql 2000.

i have changed settings within web.config

objectQualifier from dbo to dbo********

install gos fine no errors

the problem i have is after i have set up hosting disables my access to the 7x aspnet tables as the database owner is dbo and not dbo********

if i do a sql backup/restore it changes to database owner of the 7x aspnet tables to dbo******** but then dnn4.4.1 does not run as is looking for dbo.aspnet rather than the new dbo********.aspnet since restore.

is there a work around for this

either by script to update dnn to new names of database owner of aspnet tables, or to force dnn instal to name aspnet with dbo******** on initial install

sorry my wording was wrong

here is an idea of the details changed within web.config
<add
      name="SiteSqlServer"
      connectionString="Server=mssql**.server.co.uk;Database=db12345678;uid=dbo12345678;pwd=********;"
      providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<add key="SiteSqlServer" value="Server=mssql**.server.co.uk;Database=db12345678;uid=dbo12345678;pwd=********;"/>
<add
          name="SqlDataProvider"
          type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
          connectionStringName="SiteSqlServer"
          upgradeConnectionString=""
          providerPath="~\Providers\DataProviders\SqlDataProvider\"
          objectQualifier=""
          databaseOwner="dbo12345678"/>

so database db12345678 uid dbo12345678

database is blank prior to install of dnn. once installed the aspnet tables datadase owner is dbo where as all other tables is dbo12345678.

hosting are saying that i am accessing database as unauthorised user and have banned access to all tables with dbo as database owner.

i just could not understand that if i was naming the database owner as dbo12345678 why aspnet tables owner was dbo

would change hosting is never had so many pop3 mail hosted with them