---
title: "Membership and Role provider available  in ASP.Net"  
description: "Brief description of how to use the available Membership and Role provider available in ASP.NetFollow the steps given below to use built-in user store"  
author: "priyanka kushwaha"  
published: 2015-02-27  
updated: 2018-02-22  
canonical: https://www.mindstick.com/blog/794/membership-and-role-provider-available-in-asp-dot-net  
category: ".net"  
tags: ["c#", "asp.net", "authentication", "authorization"]  
reading_time: 1 minute  

---

# Membership and Role provider available  in ASP.Net

Brief description of how to use the available [Membership](https://www.mindstick.com/interview/2228/in-which-database-is-the-information-such-as-membership-role-management-profile-and-web-parts-personalization-stored) and Role provider available in ASP.Net

**Follow the steps given below to use built-in user store schema for maintaining the user information.**

1. Go to [visual studio](https://www.mindstick.com/articles/12378/visual-studio-for-mac-is-out-of-beta-preview-now-officially-available), visual studio tools and then open the Visual Studio [Command Prompt](https://answers.mindstick.com/qa/51716/how-to-make-bootable-pendrive-using-cmd-windows-command-prompt).
2. Use the aspnet_regsql.exe command to run the ASP.NET [SQL server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) setup wizard.
3. Check the option “[Configure](https://answers.mindstick.com/qa/51511/how-to-configure-client-and-repository-in-informatica-power-center) SQL Server for [application](https://www.mindstick.com/articles/12824/calculator-application-in-android) [services](https://www.mindstick.com/articles/13111/distinctions-of-iiot-services-how-its-helps-brands)”.
4. Select the server [instance](https://www.mindstick.com/forum/1739/object-reference-is-not-set-to-an-instance-of-an-object-error-in-my-code) and the [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) name for the application, if the database name is not provided, default [asp net](https://www.mindstick.com/forum/12814/asp-net-mvc-5-and-listbox-with-linq) DB database is created.
5. Click the confirm setting and finish button to create the database store.

![Membership and Role provider available  in ASP.Net](https://www.mindstick.com/blogs/b2a902b0-12b7-4fd2-ac21-eca08bb0f75f/images/65604385-873a-4037-ac5b-feeece008f03.png)

![Membership and Role provider available  in ASP.Net](https://www.mindstick.com/blogs/b2a902b0-12b7-4fd2-ac21-eca08bb0f75f/images/84f2fbbb-e9a0-4122-a490-316f25e7d4c3.png)

![Membership and Role provider available  in ASP.Net](https://www.mindstick.com/blogs/b2a902b0-12b7-4fd2-ac21-eca08bb0f75f/images/243d49b0-c224-4164-8829-1fd7700e000e.png)

![Membership and Role provider available  in ASP.Net](https://www.mindstick.com/blogs/b2a902b0-12b7-4fd2-ac21-eca08bb0f75f/images/3f162c3f-81ca-4331-a183-691672cf41ed.png)

![Membership and Role provider available  in ASP.Net](https://www.mindstick.com/blogs/b2a902b0-12b7-4fd2-ac21-eca08bb0f75f/images/c957f68b-62f9-435d-882f-eaa3fc26f2bf.png)

![Membership and Role provider available  in ASP.Net](https://www.mindstick.com/blogs/b2a902b0-12b7-4fd2-ac21-eca08bb0f75f/images/8d732649-1598-4da3-9b30-11b212fc809d.png)

---

Original Source: https://www.mindstick.com/blog/794/membership-and-role-provider-available-in-asp-dot-net

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.