Please follow this steps:
1. Log in to your Control Panel.
2. From the menu, select Databases ? SQL Server 2008.
3. Click the Create User button.
4. Enter a user name and password and click Save. In this demonstration, the user name is dotnetuser and the password is dotnetuserpass.
5. Click the Create Database button.
6. Enter a database name and grant access to the user you created above and click Save. In this demonstration the database is called DotNetAuthentication.
7. Locate and run the ASP.NET SQL Server Setup Wizard. This file is located in your .NET framework directory and is named aspnet_regsql.exe (example: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regsql.exe).
8. Click Next and choose Configure SQL Server for application services.
9. Click Next and enter the server name and database log in credentials. The server name is the web site pointer address to where your application will be published and the log in credentials are the SQL server user name and password created earlier.
10. Click Next twice and the wizard will take a moment to complete the scripting actions that populate the new database with all the objects necessary to configure the ASP.NET provider. Once complete, click Finish to close the wizard.
11. Finally, modify the web.config file in your ASP.NET web application to use the database you created.