Security Verified
Browse Categories
 Affiliates
 Backup & Restore
 Billing & MyAccount FAQs
 Control Panels
 Customer Tools
 Databases
 Dedicated Servers
 DNS and Domain Registration
 Email
 Glossary
 Network
 News
 PCI Compliance
 Postmaster
 Pre-sales FAQ
 Publishing Your Site
 Reseller Tips
 Search Engine Optimization
 Security Topics
 SSL and HTTPS
 Support: Getting Help
 Virtual Desktops
 Virtual Servers
 Website Design & Development
 Website Errors

DotNetNuke Hosting
SQL 2008 R2 / IIS 7.5 Hosting
WordPress Hosting
Forex Trader Hosting
Personal Desktop Hosting

Setting up role/membership objects in MSSQL database for ASP.net

Article ID: 799

 Back to Search

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:
    • A 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.
 
Downloads Associated With This Article
No downloads are currently associated with this article.

© 2001 - 2012 3Essentials Inc.
Terms Of Service | Privacy Policy | Copyright Policy | Affiliates