ISP Settings - Table and SP Ownership Set to DB User Name not 'dbo' (DNN 3.1.1)

Last post 11-11-2005 2:11 PM by WpgBri. 0 replies.

Sort Posts:

  • ISP Settings - Table and SP Ownership Set to DB User Name not 'dbo' (DNN 3.1.1)

    11-11-2005, 2:11 PM
    • Member
      55 point Member
    • WpgBri
    • Member since 11-06-2005, 5:55 PM
    • Posts 11
    (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

Page 1 of 1 (1 items)