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.
Chat Now

Add ASP.NET 2.0 Membership Roles to Remote SQL

You can choose to add ASP.NET roles to either an existing database or a new database. First you need to add the database in your HELM control panel.

Step 1

Log into the control panel and click on your domain name and then click on the Database Management Icon.

kb-add-asp2-remote-sql-1

Step 2

After that, click on the Add New button to add a new database.

kb-add-asp2-remote-sql-2

Step 3

Now you need to name your database and choose the type. Both SQL 2000 or 2005 are fine. In this example we will be using 2005. Insert the name and click the Save button.

kb-add-asp2-remote-sql-3

Step 4

Now we need to add users to our database so click the Add New button under database users.

kb-add-asp2-remote-sql-4

Step 5

Enter a database user name and password and click the Save button.

kb-add-asp2-remote-sql-5

Step 6

Now that we have a database created, we need to add the ASP.NET Membership roles to it. So on your Windows Server machine click Start -> Run and enter C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe which will start the ASP.NET Membership and Roles Wizard. Click Next on the welcome screen then select Configure SQL Server for application services and click Next again.

kb-add-asp2-remote-sql-6

Step 7

Now enter the SQL Server IP address and port number that you can find in the Database Manager on the connection info line. Then select SQL Server authentication and enter you user name password and database name that you created and click next.

kb-add-asp2-remote-sql-7

Step 8

Now confim that the settings are correct and click Next. (Note: It could take a few minutes for this step to complete.)

kb-add-asp2-remote-sql-8

Now if all the settings are correct just hit Finish. You have successully installed ASP Membership roles into your database.

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

Chat Now

Start Your Order

X

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.