Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Paul Sørensen 302 posts 648 karma points
    Dec 29, 2009 @ 10:38
    Paul Sørensen
    0

    Error when creating a Role

    HI

    I have a hosted site which runs fine except when I try to add a new Role. Then I get 

    A network-related or instance-specific error occurred while establishing a connection to SQL Server......

     

    What is so specific about roles?

    I run the lastest 4.0.3

    Thanks Paul S

    Copy Link
  • bayshield 50 posts 65 karma points
    Dec 29, 2009 @ 11:45
    bayshield
    0

    Hi Paul,

    Can you add members?  My guess is that something is overriding the default membership provider and looking for a DB other than the Umbraco one which doesn't exist.

    Copy Link
  • Paul Sørensen 302 posts 648 karma points
    Dec 29, 2009 @ 12:04
    Paul Sørensen
    0

    Hi

    Yes I can add members and member types - that's what so really strange

    Copy Link
  • Paul Sørensen 302 posts 648 karma points
    Dec 29, 2009 @ 12:08
    Paul Sørensen
    0

    I just tried to copy the whole site local and now I get this error:

     

     

    Cannot open database "C:\USERS\HARTVIG\DOCUMENTS\VISUAL STUDIO 2005\WEBSITES\AJAXENABLEDWEBSITE2\APP_DATA\ASPNETDB.MDF" requested by the login. The login failed.
    Login failed for user 'XPH-PAS\ASPNET'.

     

    ????

    Copy Link
  • Paul Sørensen 302 posts 648 karma points
    Dec 29, 2009 @ 12:43
    Paul Sørensen
    0

    Hi

    I believe it's a UmbracoRoleProvider problem. I have seen post indicating a problem with TrusLevel but I already have Full trust.

    There has been a change in the UmbracoRoleProvider - it's out-coomented in 4.0.3.

    My 4.0.2.1 version works fine.

    /Paul S

    Copy Link
  • Dirk De Grave 4537 posts 6006 karma points MVP 3x admin c-trib
    Dec 29, 2009 @ 12:50
    Dirk De Grave
    0

    Can you show what's in your web.config, I suspect there's a misconfiguration on the role provider

     

    Cheers,

    /Dirk

    Copy Link
  • Paul Sørensen 302 posts 648 karma points
    Dec 29, 2009 @ 14:45
    Paul Sørensen
    0

    This is the part containing the Membership

     

        <!-- Membership Provider -->
        <membership defaultProvider="UmbracoMembershipProvider" userIsOnlineTimeWindow="15">
          <providers>
            <clear />
            <add name="UmbracoMembershipProvider" type="umbraco.providers.members.UmbracoMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" defaultMemberTypeAlias="Another Type" passwordFormat="Hashed" />
            <add name="UsersMembershipProvider" type="umbraco.providers.UsersMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" passwordFormat="Hashed" />
          </providers>
        </membership>

        <roleManager enabled="true"/>
        <!-- added by NH to support membership providers in access layer
        <roleManager enabled="true" defaultProvider="UmbracoRoleProvider">
          <providers>
            <clear />
            <add name="UmbracoRoleProvider" type="umbraco.providers.members.UmbracoRoleProvider" />
          </providers>
        </roleManager>-->

        <!-- Sitemap provider-->
        <siteMap defaultProvider="UmbracoSiteMapProvider" enabled="true">
          <providers>
            <clear />
            <add name="UmbracoSiteMapProvider" type="umbraco.presentation.nodeFactory.UmbracoSiteMapProvider" defaultDescriptionAlias="description" securityTrimmingEnabled="true" />
          </providers>
        </siteMap>
        <trust level="Full" />
      </system.web>

    /Paul S

    Copy Link
  • Sebastiaan Janssen 4899 posts 14655 karma points MVP admin hq
    Dec 29, 2009 @ 14:51
    Sebastiaan Janssen
    0

    You have these two lines, I think you need to remove the first line so that the correct defaultProvider can be found:

        <roleManager enabled="true"/>
        <!-- added by NH to support membership providers in access layer 
        <roleManager enabled="true" defaultProvider="UmbracoRoleProvider">

    Copy Link
  • Sebastiaan Janssen 4899 posts 14655 karma points MVP admin hq
    Dec 29, 2009 @ 14:52
    Sebastiaan Janssen
    0

    Oh, with code highlighting I now the the problem, your rolemanager is commented out. Remove   <roleManager enabled="true"/> and enable the rolemanager block under it and you should be fine.

    Copy Link
  • Paul Sørensen 302 posts 648 karma points
    Dec 29, 2009 @ 15:41
    Paul Sørensen
    0

    Thanks Sebastiaan

    That did it.

    /Paul S

    Copy Link

  • 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