Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.

Use Microsoft Web Site Admin Tool on Shared Host

This article assumes you have already added the ASP.NET Membership/Roles Schema to a database. If not please refer to:

Add ASP.NET 2.0 Membership Roles to remote SQL

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.

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST


Start Your Order


This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.