|  Accueil
Aide

Hébergement classique et Web Aide

Granting Administrator Privileges to ASP.NET 2.0 Personal Web Site User Account

This article only applies to Web & Classic Hosting. For more information, see What type of hosting account do I have?

An ASP.NET 2.0 Personal website allows for the creation of site user accounts. After an account is created, administrator privileges can be granted through the Hosting Control Panel. Administrator accounts are permitted to manage site content after log in.

NOTE: All user accounts must be manually activated through the Hosting Control Panel after creation. For more information about activating user accounts, see Activating ASP.NET 2.0 Personal website User Account.

For more information about the ASP.NET 2.0 Personal website, see the Introduction to the Personal website Starter Kit on MSDN.

To Grant Administrator Privileges to an ASP.NET 2.0 User Account

  1. Log in to your Account Manager.
  2. Click Web Hosting.
  3. Next to the hosting account you want to use, click Launch.
  4. In the Databases section of the Hosting Control Panel, click the SQL Server icon.
  5. Next to the name of your SQL Server database, click Admin Tool. The SQL Server Web Admin tool displays.
  6. In the tree on the left, expand the Connection folder and select Connection.
  7. Enter the User Name and Password for your database. You created your user name and password when you set up your SQL server database.
  8. Expand the Tools folder on the left and select Query Analyzer.
  9. Copy the following T-SQL statement into the Query Analyzer window:

    SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'

    Click Submit and save the return value for use in step 11. Click Reset.

  10. Copy the following T-SQL statement into the Query Analyzer window:

    SELECT UserId FROM aspnet_Users WHERE UserName = ''

    Replace with the user name of the account to which administrator privileges will be granted. Retain the single quotation marks around this case-sensitive value. Click Submit and save the return value for use in step 11. Click Reset.

  11. Copy the following T-SQL statement into the Query Analyser window:

    INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('', '')

    Replace with the return value from step 9. Replace with the return value from step 10. Retain the single quotation marks around these values. Click Submit.


Cet article était-il utile ?
Nous vous remercions de votre feed-back. Pour parler avec un représentant de notre service clientèle, veuillez utiliser le numéro de téléphone du support technique ou l’option de chat présentée ci-dessus.
Nous sommes ravis de vous avoir aidé ! Y a-t-il autre chose que nous pouvons faire pour vous ?
Nous sommes désolés de ce problème. Dites-nous ce qui n’était pas clair ou pourquoi la solution n’a pas résolu votre problème.