(Note as of 20 Nov 05 - it was a web.config error; the dbo entry at the end had been changed to DB_User. Very bad!)
I'm trying to set up a DNN site at a MS-certified hosting facility I've
been using for a couple years. They've run the install scrip for me,
and the site comes up fine. However, extra modules I add don't function
properly. The free store and a BulkReg module examples. It seems the
initial setup isn't exactly right.
It appears to be a Table and SP ownership issue. The base install
creates a lot of tables with my DB User as 'owner'. The Store created
tables with dbo as owner, but won't function at all. The BulkReg keeps
failing when trying to add Users by looking for Tables with my DB User
as owner. I've given my DB User full rights to the 3 tables involved
and it still doesn't work. These were aspnet_Membership, aspnet_Users
and another.
It definitely appears to be a permissions problem of some sort. I had
the host make dbo owner of all Tables and SPs and my DB User full
rightrs to everything. This causes the whole site to fail. The IIS call
fails looking for a DB User owned SP.
It seems the host facility didn't set some specific marker correctly
during the base install. That's my guess anyway, since tables and SPs
are creahed with my DB User as owner.
Any suggestions on what I should advise them to do.
Regards
Brian