Hi,

I'm having a BIG problem, this is my 3rd day looking for answer !

I'm trying to create a custom membership provider with MS SQL database 2005 but not the default ASPNETDB.
I've changed the web.config to be as following:

But when I try to login to the site using the login control the following error occurs:

Line 149:    <roleManager>
Line 150:      <providers>
Line 151:        <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 152:        <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 153:      </providers>

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.213

 It is clear that this is a prblem with my Machine.Config file - since I've "worked!" on this file for a while. But when I've checked the Machine.config file I've found the LocalSqlServer connection it is talking about! .

I'm lost and I dunno what to do, can anyone help?

Here is the mahine.config in case if you need it:

I'm having a little trouble following your example, but let me post a very simple working example I use that basically does the same thing.  Hopefully this will keep you from a fourth day.

<connectionStrings>  
   <add name="CMS"
     connectionString="Data Source=2.2.2.2;Initial Catalog=DBDev;Persist Security Info=True;User ID=db;Password=db1"
     providerName="System.Data.SqlClient"/>
</connectionStrings>

 <system.web>

 <roleManager defaultProvider="SqlRoleProvider" enabled="true" cacheRolesInCookie="true" cookieName=".ASPROLES" cookieTimeout="30" cookiePath="/" cookieRequireSSL="false"   cookieSlidingExpiration="true" cookieProtection="All">
    <providers>
     <clear/>
     <add name="SqlRoleProvider" type="MyMembership.SqlRoleProvider" connectionStringName="CMS"
       applicationName="DB" writeExceptionsToEventLog="false"/>
    </providers>
   </roleManager>
   <membership defaultProvider="SqlMembershipProvider" userIsOnlineTimeWindow="15">
    <providers>
     <clear/>
     <add name="SqlMembershipProvider" type="MyMembership.SqlMembershipProvider" connectionStringName="CMS"
       applicationName="DB" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false"
       requiresUniqueEmail="true" passwordFormat="Hashed" minRequiredNonalphanumericCharacters="0" writeExceptionsToEventLog="false"
       minRequiredPasswordLength="1" passwordStrengthRegularExpression="" passwordAttemptWindow="10" maxInvalidPasswordAttempts="8" />
    </providers>
   </membership>
  

 Hi there,

              try overriding the roleManager node in the Web.config file; actually you are not setting your role custom provider. Here is an example

    <roleManager defaultProvider="MySqlRoleProvider" enabled="true" >
      <providers>
        <clear />
        <add name="MySqlRoleProvider" connectionStringName="SqlConn" type="System.Web.Security.SqlRoleProvider" applicationName="/" />
      </providers>
    </roleManager>

              I hope it helps.

Regards,

Fernando 

It works for me.

Thanks Fernando!

your problem was on a local machine or on the hosted server?

I have the same kind of problem

pkellner,

Thank you very much about your reply, which - unfortunalty- was not been tracked by me from the first place to fix my problem since I gaved up and stared building everything all over again!

I wish I gave it another shoot and look for answers for my post! But thanks anyway for your reply

norchou,

It was in the local machine, but I can assume that the same problem will happen in the host server too since the membership provider was not configured correctly.