This article assumes you have already added the ASP.NET Membership/Roles Schema to a database. If not please refer to:
We will be using Visual Web Developer Express and a database name aspdotnetroles, however you can use any database you like.
First thing you need to do is change the web.config of your application to use your remote SQL server settings. Just insert the following code into your web.config:
Obviously you need to change this line to relect your database connection information. Then save your web.config.
Now you should be able to launch the Administration tool from Visual Web Developer Express.
After a few seconds your browser should load the Adminstration welcome page.
Now we need to set the site to authenticate in an SQL database and not use Windows Authentication. Click on the application configuration and select the internet option and hit done.
Now we need to add some Roles to our site. Click on the Security tab and then click on Create or Manage Roles.
For now we are going to just add two roles to our application an “Admin” role and a “User” role. So Enter “Admin” and hit “Add role” and then do the same for “User”.
Now we need to create some user and add them to the roles. Click on the Security tab and then click on Create User. Enter the login information for the Admin user and check the box for the Admin role.
Now do the same and create a user for the user role.
Now if everything worked as it should you should be able to go back the Security tab and Click on “Manage users” and see the users you just created.
Now you just need to implement the authentication into your site. Which will be covered in later how-to.