Asp.net Web Site Administration Tool with SqlCeMembership
        Posted  
        
            by 
                Riderman de Sousa Barbosa
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Riderman de Sousa Barbosa
        
        
        
        Published on 2011-07-08T13:10:33Z
        Indexed on 
            2012/04/07
            17:29 UTC
        
        
        Read the original article
        Hit count: 346
        
I am developing an application in MVC 3.
I installed this provider via Nuget .
Basically, it allows to use any part of memberships, rules and profiles with a .sdf (compact) database.
I need the "Web Site Administration Tool" use this provider. But I can not use it.
Already checked the web.config and everything is ok.
When I open the "Web Site Administration Tool" on the Security I click test (any provider) and the error happens.
The following images.

Error when clicking test

"Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."
Here part of my web.config
<authentication mode="Forms" />
<membership>
      <providers>
        <add 
          connectionStringName="SqlCeServices" 
          applicationName="/"
          enablePasswordRetrieval="false" 
          enablePasswordReset="true" 
          requiresQuestionAndAnswer="false"
          requiresUniqueEmail="true" 
          passwordFormat="Hashed" 
          writeExceptionsToEventLog="false"
          name="SqlCeMembershipProvider" 
          type="ErikEJ.SqlCeMembershipProvider, ErikEJ.SqlCeMembership" />
      </providers>
    </membership>
    <profile enabled="false">
      <providers>
        <clear />
        <add 
          name="SqlCeProfileProvider" 
          type="ErikEJ.SqlCeProfileProvider" 
          connectionStringName="SqlCeServices" 
          applicationName="/" />
      </providers>
    </profile>
    <roleManager>
      <providers>
        <add 
          connectionStringName="SqlCeServices" 
          applicationName="/"
          writeExceptionsToEventLog="false" 
          name="SqlCeRoleProvider" 
          type="ErikEJ.SqlCeRoleProvider, ErikEJ.SqlCeMembership" />
      </providers>
    </roleManager>
  <connectionStrings>
    <add name="SqlCeServices" connectionString="data source=|DataDirectory|\SqlCeAspnetdb.sdf" />
  </connectionStrings>
© Stack Overflow or respective owner