Question: How do I get ASP.net Role Management, Membership, Profile management objects or other ASP.NET application services support added to my MSSQL database to support for my ASP.net application.

Answer:

1. Create your MSSQL database and database user in your control panel first.
2. Assess which application services you need support for:

   • all|m|r|p|c|w

     Adds support for one or more ASP.NET application services. Service identifiers can be specified together or separately. The following identifiers are used for ASP.NET application services: all - All services, including common tables and stored procedures shared by the services m - Membership r - Role Manager p - Profile c - Web Parts Personalization w - Web Events

3. Submit a support request asking the support team execute aspnet_regsql.exe to set up role/membership objects on your database, formatted in the following manner:

• Please execute aspnet_regsql.exe to set up Role Management and Membership objects on my database given the following information:
  • ASP.net Framework version:  _____
  • Database name:  _______________
  • *(no profile management) I understand that 3Essentials will execute the ASP.net application services utility "aspnet_regsql.exe" with the options "-A mr" to add objects (tables, views, stored procedures, etc) to support ASP.net Application Services for Membership and Role Management  to my database.  I understand if any objects already existing within my database have the same name as these objects added by aspnet_regsql, they may be replaced by the objects created by aspnet_regsql.
  • OR
  • *(with profile management) I understand that 3Essentials will execute the ASP.net application services utility "aspnet_regsql.exe" with the options "-A mrp" to add objects (tables, views, stored procedures, etc) to support ASP.net Application Services for Membership/Role/Profile Management  to my database.  I understand if any objects already existing within my database have the same name as these objects added by aspnet_regsql, they may be replaced by the objects created by aspnet_regsql.
  • OR
  • *other - please specify the options required (i.e., -A all, or -A cw, etc, as meets your requirements): I understand that 3Essentials will execute the ASP.net application services utility "aspnet_regsql.exe" with the option(s) I am specifying as: ____________ to add objects (tables, views, stored procedures, etc) to support ASP.net Application Services for Membership/Role/Profile Management/other ASP.net Application Services  to my database.  I understand if any objects already existing within my database have the same name as these objects added by aspnet_regsql, they may be replaced by the objects created by aspnet_regsql.