• Login
  • Register

DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

Install DNN in a custom database schema

You are not authorized to post a reply.
Sort:


New Member


Posts:3
New Member

    Hi

    I'd like to know if DNN supports the installation in a custom database schema.
    I've tested the old object qualifier setting by the past but never the database owner setting.

    I set a database with a specific login who owns a custom schema named 'dnn'.
    When I connect to the server with this login. I can run create query and see that it creates objects in the 'dnn' schema instead of the dbo one. But when I try to install DNN with those credentials, it create all the objects in the 'dbo' schema.

    I tried with option 'run database as databse owner' checked and unchecked.

    The best result I've got is: 'The specified schema name "dbo" either does not exist or you do not have permission to use it.', 'CREATE TABLE dbo.[Authentication] ...'.
    I set the databaseOwner settings in the web.config to 'dnn' but the installation process always change it to 'dbo.'.

    You are not authorized to post a reply.

    These Forums are dedicated to discussion of DNN Platform.

    For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

    1. If you have (suspected) security issues, please do not post them in the forums but send an email to [email protected]
    2. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
    3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
    4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
    5. No Flaming or Trolling.
    6. No Profanity, Racism, or Prejudice.
    7. Site Moderators have the final word on approving / removing a thread or post or comment.
    8. English language posting only, please.

    Would you like to help us?

    Awesome! Simply post in the forums using the link below and we'll get you started.

    Get Involved