A quick how-to. I've done this a dozen times and figured I might as well make an entry in relation to it since I always have to look up where that blasted SQL file is or a step here or there. So with that, a quick and dirty how to on setting up ASP.NET 2.0 Membership, Roles, and Users in SQL Server 2000 or SQL Server 2005.
- First thing, get an empty database setup on the database server. It really doesn't matter what it is named, how it is configured or anything like that. You just need a database. You can even have other objects in the database; tables, stored procedures, etc. but they'll be deleted.
- Next find the aspnet_regsql.exe executable. This file is usually located in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 folder. Once you find the file, execute it.
- The next screen that pops up will be a standard wizard. Now at this point all the reminders needed have been provided. Pick which database you want to install the tables and procs on and continue on through to the end of the wizard.
So that's it. Now you're ready to setup users, roles, properties/membership information and even extend the data, classes, or other API functionality.
I dug up the following info searching around for this information my last go round.