> ## Documentation Index
> Fetch the complete documentation index at: https://kb.mochahost.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Register ASP.NET SQL Provider

## ASP.NET includes a SQL Server provider for the following ASP.NET features:

**Membership** (the [SqlMembershipProvider](https://docs.microsoft.com/en-us/dotnet/api/system.web.security.sqlmembershipprovider?view=netframework-4.8) class).

**Role management** (the [SqlRoleProvider](https://docs.microsoft.com/en-us/dotnet/api/system.web.security.sqlroleprovider?view=netframework-4.8) class).

**Profile** (the [SqlProfileProvider](https://docs.microsoft.com/en-us/dotnet/api/system.web.profile.sqlprofileprovider?view=netframework-4.8) class).

**Web Parts personalization** (the [SqlPersonalizationProvider](https://docs.microsoft.com/en-us/dotnet/api/system.web.ui.webcontrols.webparts.sqlpersonalizationprovider?view=netframework-4.8) class).

**Web events** (the [SqlWebEventProvider](https://docs.microsoft.com/en-us/dotnet/api/system.web.management.sqlwebeventprovider?view=netframework-4.8) class).

To register your database as ASP.NET provider you need to run the Aspnet\\\_regsql.exe tool, which can be found in

**C:%windir%\Microsoft.NET\Framework\aspnet\\\_regsql.exe**

### When the wizard starts:

1. Select "Configure SQL for application service"

2. Enter the following:\
   *Server* - use the server address listed in "Database server" field when you were creating your database in Plesk\
   Select SQL Server authentication *User name* - enter the database user that you have setup in Plesk.\
   *Password* - enter the database password that you have setup in Plesk.\
   *Database* - enter the database name that you have setup in Plesk.

3. Proceed to next screen and finish the setup.