Membership

Create new membership database

Purpose

To create a sql file that will create a new membership database

Code

This code will create a SQL file that you can execute in SSMS

Step 1

Execute cmd.exe, if in vista run as adminstrator

Step 2

Enter the command cd \windows\microsoft.net\framework\v2.0.50727\

Step 3

Enter the command aspnet_regsql.exe -E -S localhost -d Northwind -A all -sqlexportonly c:\membership.sql

Step 4

In windows, edit the membership.sql file to your needs, you can search for SET @dbname = N'Northwind' and replace Northwind with whatever name you'd like. This will be the name of the database you create.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License