Home > ASP.NET > Create a ASP.NET Membership Security Database

Create a ASP.NET Membership Security Database

Here I will explain how to add ASP.NET 2.0 Membership Security tables, stored procedures, views to your existing SQL Server database – its simple! Here’s how:
 
Prerequisites:
Visual Studio 2005 installed
SQL Server 2005 installed (with a current database and your windows account with dbo/admin rights)
  1. Locate your SQL Database – make sure you have rights to it
  2. Locate the Visual Studio Command Prompt (All Programs > Microsoft Visual Studio 2005 > Visual Studio Tools > Visual Studio 2005 Command Prompt)
  3. Run the following command: aspnet_regsql -S (local) -E -d MyDatabaseName -A all

Note:  Change (local) to your SQL database server name if it is not local. Change MyDatabaseName to your database name (suggest you create a test database first to test this on – don’t do directly on production database!)

DONE!  Now have a look at your database. You should see a whole lot of new tables and stored procedures etc within your database.

For more help on the switches on the command above, type: aspnet_regsql /? within the Visual Studio 2005 Command Prompt.

Any questions about the above process then feel free to post a comment and I will reply.

Yellow Duck Guy
Greg Olsen

About these ads
Categories: ASP.NET
  1. Aljika Kisuno
    October 28, 2009 at 8:49 pm

    Thanks! This\’s very useful.

  2. Kabir
    July 17, 2012 at 1:09 am

    Its a Very Short Way to create Membership Database

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 528 other followers

%d bloggers like this: