Export (0) Print
Expand All
0 out of 3 rated this helpful - Rate this topic

Creating and Configuring the Application Services Database for SQL Server

Many features of ASP.NET rely on intrinsic application services such as membership, roles, profiles, and personalization. The application services use providers, objects that persist application service data in long-term storage. For example, the ASP.NET personalization service uses a personalization provider to save personalized user settings on Web pages.

Each application service uses one provider to persist the service's data in a particular kind of data store. For each service, a SQL provider is included and configured as the default provider to persist the data in a Microsoft SQL Server database.

NoteNote

To persist ASP.NET application services data in another data store besides SQL Server (such as a Microsoft Access database, XML files, or other RDBMS systems), you must create a separate provider for each kind of data store. To create a custom provider, you can inherit from the base provider for a particular application service, and extend it to handle the data for the service in whatever type of data store you plan to use. For example, to create an Access database provider for the membership service, you could inherit from the MembershipProvider base class, and enable it to persist membership data in Access.

The topics in this section provide details to create, configure, secure, and connect to the application services database for SQL Server.

Creating the Application Services Database for SQL Server

Demonstrates how to use the aspnet_regsql.exe tool to create a new instance of the application services database hosted by SQL Server.

Roles and Views in the Application Services Database for SQL Server

Explains the SQL Server database security roles and views included in the application services database.

Role Management Providers

Describes the role management application service.

Managing Users by Using Membership

Describes the membership application service.

Web Parts Personalization Overview

Describes the capabilities of the personalization service.

ASP.NET Profile Properties Overview

Describes the user profiles application service.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.