Activating ASP.NET 2.0 Personal Web Site User Account
ASP.NET 2.0 user accounts must be manually activated through the Hosting Control Center after creation.
For more information about the ASP.NET 2.0 Personal website, see the Introduction to the Personal website Starter Kit on MSDN.
To Activate an ASP.NET 2.0 User Account
- Log in to your Account Manager.
- Click Web Hosting.
- Next to the hosting account you want to use, click Launch.
- In the Databases section of the Hosting Control Center, click the SQL Server icon.
- Next to the name of your SQL Server database, click Manage via.... The SQL Server Web Admin tool displays.
- In the tree on the left, expand the Connection folder and select Connection.
- Enter the User Name and Password for your database. You created your user name and password when you set up your SQL server database.
- Expand the Tools folder on the left and select Query Analyzer.
- Copy the following T-SQL statement into the Query Analyzer window:
SELECT UserId FROM aspnet_Users WHERE UserName = '<username>'Replace <username> with the user name of the desired account. Retain the single quotation marks around this case-sensitive value. Click Submit and save the return value for use in step 10. Click Reset.
- Copy the following T-SQL statement into the Query Analyzer window:
UPDATE aspnet_Membership SET IsApproved = 1 WHERE UserId = '<userID>'Replace <userid> with the return value from step 9. Retain the single quotation marks around this value. Click Submit.
Rate This Article:
Related Topics:
Related Articles:
Connecting to a SQL Server Database Using ASP.NET 3.5
How do I enable Windows hosting accounts to show more detailed error messages?
Using CDOSYS to Send Email from Your Windows Hosting Account
What Is Medium trust level and how does it affect my hosting account?
What server objects are supported on Windows shared hosting servers?
What email or relay server should I use in my ASP.NET 3.5 code?
What is the absolute or direct path for my Windows (ASP) hosting account?
How do I enable Windows hosting accounts to show more detailed error messages?
Using CDOSYS to Send Email from Your Windows Hosting Account
What Is Medium trust level and how does it affect my hosting account?
What server objects are supported on Windows shared hosting servers?
What email or relay server should I use in my ASP.NET 3.5 code?
What is the absolute or direct path for my Windows (ASP) hosting account?
Sending Message...Have a question about the content of this article?
0 min expected wait time
