Frequently Asked Questions

Setting up Your Database with the ASP.NET 2.0 Schema

Last Updated: May 7, 2007 1:36 PM

In order to use some of the personalization, membership, and roles features of ASP.NET 2.0, you need to set up your SQL Server database with the ASP.NET 2.0 schema.

You can set up the ASP.NET 2.0 schema when you create a new database in your hosting manager, or after you create a SQL Server database.

NOTE: You must enable ASP.NET 2.0 on you hosting account before you can create a database with the ASP.NET 2.0 schema.

To Set up Your SQL Server Database with the ASP.NET 2.0 Schema

  1. Log in to your Account Manager.
  2. In the My Products section, select Hosting Account List.
  3. Next to the hosting account you want to modify, click Open.
  4. In the Databases section of the Hosting Control Center, click the SQL Server icon.
  5. Click Create New Database.
  6. If you want to use DSN with this database, select Create DSN.
  7. To add support for the SQL Server ASP.Net, click Install Schema Features.
  8. Enter a user name and password, and click Continue.
  9. Verify your SQL Server database settings. If everything looks OK, click Create Database.

If you already have a SQL Server set up, you can add support for the SQL Server ASP.Net by clicking on the pencil icon next to your database and then select the Install Schema Features option.