Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Bob 38 posts 160 karma points
    Jul 31, 2017 @ 19:17
    Bob
    0

    Installing Umbraco

    I'm installing umbraco and when i enter the database and server name the database adds a schema name to all the table names. How could i avoid this?

  • Nicholas Westby 2005 posts 6843 karma points c-trib
    Jul 31, 2017 @ 22:06
    Nicholas Westby
    0

    Are you talking about when it says something like dbo.cmsContent? I think the dbo portion is just something SQL does (though, I've never really questioned it, so I don't know). Is there some reason you don't want that (assuming I've understood your question correctly)? You can still query tables without specifying the schema.

  • Bob 38 posts 160 karma points
    Aug 01, 2017 @ 05:41
    Bob
    0

    Yes, dbo.cmsContent becomes Iis_apppool\user.cmsContent. I don't know why it does it but like to keep it to the original naming.

  • Nicholas Westby 2005 posts 6843 karma points c-trib
    Aug 01, 2017 @ 06:12
    Nicholas Westby
    0

    That sounds odd. Not sure exactly why that would happen, but I would guess it has something to do with how you've configured the permissions for the login or the user in the SQL database.

  • Nik 1413 posts 6212 karma points MVP 3x c-trib
    Aug 01, 2017 @ 09:46
    Nik
    0

    In the past, that has very much been caused by how the user you are using to create the database is configured. I can't however, remember how to stop it I'm afraid.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies