How to configure the ASP.NET Membership/Roles Provider to use SQL 2000, SQL 2005, SQL 2008 or SQL2012.

This article describes how to configure the ASP.NET Membership/Roles provider to use SQL 2000, SQL 2005, SQL 2008 or SQL2012

The following steps create the full Application Services database schema on our SQL Server database.

1. Open the command prompt on your local computer, and navigate to: C:\WINDOWS\Microsoft.NET\Framework\[framework version]
2. Execute the command: aspnet_regsql.exe -S DBServerName -U DBLogin -P DBPassword -A all -d DBName

Currently, there is no management interface to manage the membership database besides using Visual Web Developer or creating your own application using the membership provider class.

Below is an example of how to configure Visual Studio or Visual Web Developer to manage the membership database.

    1. Create a web application in Visual Web Developer or Visual Studio.
    2. Open the web.config.
    3. The default membership provider uses a connection string called "LocalSqlServer". Therefore, replace:

<connectionStrings/>

        with 

<connectionStrings>
  <remove name="LocalSqlServer" />
  <add name="LocalSqlServer" connectionString="Data Source=DBServerName;Integrated Security=false;Initial Catalog=DBName;User ID=DBLogin;Password=DBPassword" providerName="System.Data.SqlClient" />
</connectionStrings>

    4. Save and close the web.config.
    5. Go to Website menu, and run the ASP.NET Configuration tool. This will open the Web Site Administration tool.
    6. In the Web Site Administration tool, go to the Security tab.
    7. Click on "Select authentication type".
    8. Select "From the internet". Click the Done button.
    9. Create your admin roles and users.
    10. Then create access rules.
    11. Create a rule that applies to the "Anonymous users" with "Deny" permissions.
    12. Create another rule that applies to the admin role you created with "Allow" permissions.

 Your application is now ready to use the membership provider, and you can begin creating your login forms
If you run into problems when using this code, please post in our community forum. Technical support is unable to assist with specific coding issues.