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 304 posts 650 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

  • 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.

  • Paul Sørensen 304 posts 650 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

  • Paul Sørensen 304 posts 650 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'.

     

    ????

  • Paul Sørensen 304 posts 650 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

  • Dirk De Grave 4541 posts 6021 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

  • Paul Sørensen 304 posts 650 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

  • Sebastiaan Janssen 5058 posts 15520 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">

  • Sebastiaan Janssen 5058 posts 15520 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.

  • Paul Sørensen 304 posts 650 karma points
    Dec 29, 2009 @ 15:41
    Paul Sørensen
    0

    Thanks Sebastiaan

    That did it.

    /Paul S

Please Sign in or register to post replies

Write your reply to:

Draft