Adding a SQL Server Membership Provider using the aspnet_regsql.exe Utility

You may add a SQL Server Membership Provider using the aspnet_regsql.exe Utility on either your SQL Server Express local database or on a full-blown SQL Server database. In both implementations, you would use the aspnet_regsql.exe utility. This tool is installed when you install your .NET Framework. To use this on your SQL Server 2008 database server, for instance, you would need to first download and install the .NET Framework onto your server.

Then you would need to find the location of the aspnet_regsql.exe utility on your drive. Here is the path to mine using the .NET Framework 4: C:\Windows\Microsoft.NET\Framework64\v4.0.30319

I also like to create a shortcut to the utility on my desktop so I have it for future.

Here is an article I wrote in 2007 with step by step instructions and images for Adding a SQL Server Membership Provider using the aspnet_regsql.exe Utility.

Here is another useful link on deploying the database without including your test user accounts:

How to: Deploy the ASP.NET Membership Database without Including User Accounts