i have a problem, i am using dnn 4.4.1 and for install hosting requires the database owner changed within the web.config i have done this and install is ok
<providers>
<clear/>
<add
name="SqlDataProvider"
type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
connectionStringName="SiteSqlServer"
upgradeConnectionString=""
providerPath="~\Providers\DataProviders\SqlDataProvider\"
objectQualifier=""
databaseOwner="dbo*******"/>
</providers>
the problem i have is that in database tables the x7 aspnet tables database owner is DBO, any DNN tables are DBO*******
if i do a backup and restore of my database all tables (including aspnet) are DBO*******
the database is just created prior install so is clean.
means i have no way to backup/restore my site if anything gos wrong!! - the hosting is with 1and1 and is set at medium trust
when i tried restore i got this error
[SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_Membership_GetUserByName'.]
i think because it is looking for DBO_ASP rather than DBO*******_ASPNET that it is now since restore
anyhelp would be great