By default, .Net membership, profile and role management are using "aspnetdb.mdf"
<connectionStrings>
<add name="ApplicationServices"
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
providerName="System.Data.SqlClient" />
</connectionStrings>
Then can I change my asp.net membership database to SQL Server? The answer definitely is yes, let us do it step by step together.
Step 1 Creating the Application Services Database for SQL Server
http://msdn.microsoft.com/en-us/library/x28wfk74.aspx
aspnet_regsql.exe -E -S localhost -A mr
note: The Aspnet_regsql.exe tool is located in thedrive:\WINDOWS\Microsoft.NET\Framework\versionNumber folder on your Web server
Step 2 Configuring an ASP.NET Application to Use Membership
http://msdn.microsoft.com/en-us/library/6e9y4s5t.aspx
2.1 Add new connectionstring "MysqlConnection"
2.2 Modify "connectionStringName" of membership,profile,roleManager provider accordingly
<configuration>
<connectionStrings>
<add name="MySqlConnection" connectionString="Data
Source=MySqlServer;Initial Catalog=aspnetdb;Integrated
Security=SSPI;" />
</connectionStrings>
<system.web>
<authentication mode="Forms" >
<forms loginUrl="login.aspx"
name=".ASPXFORMSAUTH" />
</authentication>
<authorization>
<deny users="?" />
</authorization>
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
<providers>
<clear />
<add
name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="MySqlConnection"
applicationName="MyApplication"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
requiresUniqueEmail="true"
passwordFormat="Hashed" />
</providers>
</membership>
</system.web>
</configuration>