Select a Default Membership Provider (IIS 7)

Applies To: Windows 7, Windows Server 2008, Windows Server 2008 R2, Windows Vista

IISĀ 7 includes the following default provider for users:

  • SQL Server (AspNetSqlMembershipProvider) - User information is stored in a SQL Server database. The SQL provider is suited for medium-to-large Internet applications. This is the default provider.


For information about the levels at which you can perform this procedure, and the modules, handlers, and permissions that are required to perform this procedure, see .NET Roles Feature Requirements (IIS 7).

Exceptions to Feature Requirements

  • None

To select a default provider for roles

You can perform this procedure by using the user interface (UI), by editing configuration files directly, or by writing WMI scripts.

User Interface

To use the UI

  1. Open IIS Manager and navigate to the level you want to manage. For information about opening IIS Manager, see Open IIS Manager (IIS 7). For information about navigating to locations in the UI, see Navigation in IIS Manager (IIS 7).

  2. In Features View, double-click .NET Users.

  3. In the Actions pane, click Set Default Provider.

  4. In the Edit .NET Users Settings dialog box, select a provider from the Default Provider drop-down list, and then click OK.

Command Line



The procedure in this topic affects the following configuration element:

<membership> under <system.web>

For more information about IISĀ 7 configuration, see IIS 7.0: IIS Settings Schema on MSDN.


Use the following WMI classes, methods, or properties to perform this procedure:

  • MembershipSection.DefaultProvider property

For more information about WMI and IIS, see Windows Management Instrumentation (WMI) in IIS 7. For more information about the classes, methods, or properties associated with this procedure, see the IIS WMI Provider Reference on the MSDN site.

See Also


Configuring .NET Roles in IIS 7
Configuring .NET Users in IIS 7