Web Site Administration Tool change membership provider to MySQLMembershipProvider

See more:

C#

ASP.NET

Visual-Studio

I am trying to follow this tutorial http://dev.mysql.com/doc/refman/5.7/en/connector-net-tutorials-asp-roles.html/

Thing is im always running into the same problem. When i change the membership provider to MySQLMembershipProvider i get this error when i click on security.

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: The source was not found, but some or all event logs could not be searched. To create the source, you need permission to read all event logs to make sure that the new source name is unique. Inaccessible logs: Security.



code for web.config connection

<connectionStrings>
      <remove name="LocalMySqlServer"/>
      <add name="MySqlMembershipProvider" connectionString="server=000.000.000.000;User Id=benoatsc_admin;database=*****;password=****;Persist Security Info=True"
        providerName="MySql.Data.MySqlClient" />
    </connectionStrings>

code for machine.config

<membership defaultProvider="MySqlMembershipProvider">
           <providers>
               <clear/>
               <add name="MySqlMembershipProvider"
                     type="MySql.Web.Security.MySQLMembershipProvider, mysql.web"
                       connectionStringName="Greenfilm"
                       enablePasswordRetrieval="false"
                       enablePasswordReset="true"
                       requiresQuestionAndAnswer="false"
                       requiresUniqueEmail="true"
                       passwordFormat="Hashed"
                       maxInvalidPasswordAttempts="5"
                       minRequiredPasswordLength="6"
                       minRequiredNonalphanumericCharacters="0"
                       passwordAttemptWindow="10"
                       applicationName="/"
                       autogenerateschema="true"/>
           </providers>
       </membership>
       <profile>
         <providers>
           <add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
           <add name="MySQLProfileProvider" type="MySql.Web.Profile.MySQLProfileProvider, MySql.Web, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="Greenfilm" applicationName="/" />
         </providers>

I have been at this now for 4 days redoing the same tutorial from over and over, still comes back to the problem.

Thanks

Ben.