The ASP.NET SQL Server registration tool (Aspnet_regsql.exe) is used to create a Microsoft SQL Server database that is used by the SQL Server providers in ASP.NET. The tool is also used to add or remove options from an existing database.

You can run Aspnet_regsql.exe without any command-line arguments to run a wizard that will walk you through specifying connection information for your SQL Server installation, and installing or removing the database elements for the membership, role management, profile, Web Parts personalization, and health monitoring features.

goto [ c: -> windows folder -> Microsoft.NET folder -> Framework folder -> folder with version like v 4.0, v3.5 and select the file "aspnet_regsql.exe" ]

step 1: After double click the "aspnet_regsql.exe" file, the below

step 2: Click Next to continue the wizard. And select the "Configure SQL server application services"

step 3: Click Next to continue the wizard. And select the "Server and Database."

step 4: View the Setting summary details.

step 5: By click finish to Complete the configuration.