How to create ASPNETDB database using aspnet_regsql tool?


Microsoft has introduced a new and powerful default database schema in ASP.Net 2.0 as ASPNETDB.mdf database. This database file serves as a role provider, membership provider and web parts personalization handling with the help of BLOBs.

Visual Web Developer 2005 supports the ASP.Net configuration to manage this personal ASPNETDB database file within the web application inside the App_Data folder.

Uses of ASPNETDB database:

  1. ASPNETDB database helps in managing users along with their roles e.g. admin, employee, editors, etc.
  2. It also enables the in-built functionality of Login controls and web parts to be integrated on ASP.Net 2.0 web pages that helps in managing user profiles, login, and personalized user pages very easily even without writing the bulky code to implement the SQL queries or stored procedures along with data access code for inserting, updating or deleting the user personalized data.

How to use ASPNETDB database?

Firstly, you need to merge ASPNETDB with your own database. You can merge both databases using a tool called "aspnet_regsql". You can use aspnet_regsql command to create ASPNETDB database. This command executes the default scripts to create the default database for ASP.Net 2.0 web applications.

Steps to create ASPNETDB database using aspnet_regsql tool:

  1. Open the Visual Studio 2005 command prompt from Start -> All Programs -> Microsoft Visual Studio 2005 -> Visual Studio Tools -> Visual Studio 2005 Command Prompt
  2. Type aspnet_regsql and press enter key. This will open the ASP.Net SQL Server Setup Wizard. Click Next to continue
  3. In the next dialog box, select the option Configure SQL Server for application services. This option executes a script to configure the database for managing user profiles, roles, membership and personalization. Click Next to continue
  4. In this step enter the SQL server name and choose the right authentication method. Leave the database field to default and click Next
  5. Confirm your settings and click Next to finish

Once you merge both databases using above steps, you need to upload them on live server. For more information on aspnet_regsql tool you can refer to this URL ...

Related Articles

How to send Emails via ASP using SMTP authentication?

This topic includes the sample code to send email from ASP.Net using C# code :Sample Code :...

Sample script for CDO email

CDO (Collaboration Data Objects) is an inbuilt ASP component used to send emails via ASP. It is...

How to use Dundas Mailer?

A. Sending an Email with the QuickSend Method <% Dim objMailer 'Mailer control Set...

How to use ASPSMS?

Here is the ASP VB-Script example, intended to be used on an IIS (Internet Information Server)...

Microsoft Access and ASP connection script for Windwos 2008 / 2012 shared hosting

We don't offer Windows 2008 or Windows 2012 Shared Hosting Service anymore but we now offer...

  • 42 Users Found This Useful

Was this answer helpful?