aspnet_regsql utility provided under the framework folder helps to install the SQLServer 2005 membership database to use with ASP.NET.
Steps:
1) Navigate to Frameworkfolder
Framework folder is located under %WINDIR%\Microsoft.NET\Framework\v2.0.50727>
2) Run the utility
aspnet_regsql.exe
A GUI interface "ASP.NET SQL Server Setup Wizard" Opens, and follow the instructions which is quite simple. Asks to remove or setup application services and second step to specify the Server and Database .
