Installing Asp .Net Membership Tables



In this short blog post I will show you how to install Asp .Net Membership tables in your Existing database. If you are new to Asp .Net Membership concept you can read about each one of them in details at following MSDN article.

Asp .Net Membership Providers

So let's say you have an existing database with all the tables related to your application. The good thing about Asp .Net Membership is that you can enable it at any point in your application. For demo purposes I will be installing these tables into an empty database but you can add them to along side your existing tables in your existing database.

First of all we need to get the exe named aspnet_regsql.exe. This is the tool we will use to install Application services tables in our database. You can find out this toll at following location.

drive:\%windir%\Microsoft.NET\Framework\version

In my case the Windows OS is installed on C drive so this exe is located at following location on my machine. You should be able to locate this file likewise on your machines too.

C:\Windows\Microsoft.NET\Framework\v2.0.50727

Next thing to do is create/modify the database where we need to install these Application Services tables. I have created a temporary database AppServicesTest in my local SQL Server instance.

TestDatabase

Next, let's fire up the aspnet_regsql.exe that comes as part of .Net Framework installation. Next few screen shots will show you how you can use this tool to install the application. First screen is the welcome screen, go ahead and click next.

aspnet<em>regsql</em>1

Next it will ask you if you want to Insert or Remove the Asp .Net application services tables for a database. Go ahead and select first option.

aspnet<em>regsql</em>2

Select the appropriate SQL server instance and appropriate SQL Server database where you want to install these schema. In my case it is the test database I have created, AppServicesTest

aspnet<em>regsql</em>3

Next couple of screens will be the summary and success windows. Go ahead and click through them and finish the installation.

aspnet<em>regsql</em>4

aspnet<em>regsql</em>5

Now, let go look at our database and see if the tables were created successfully in our database.

ApplicationServiceTables

And as expected, the tables are created into your existing database.