he IDE, above the toolbar click on Website
Then ASP.NET Configuration. This will open a new browser page called ASP.Net Web Site Administration Tool
Here you click on Security. In the Security section there are three areas to setup users, roles and access rules.
You need to first create a role calle 'Administrators', fukky spelled out, 'Admin' or 'Admins' will not work.
After that you can add that role to any users you like.

Rick

Hi there,

You can find ASP.NET Configuration at the right top of the Solution Explorer.

Hope this helps...

Ron.  

Not if you're using VWD, which many of us are.

I see no way to do this whatsoever in VWD.

Start VWD and load up the clubsite.

At the top of the screen look for File - Edit - View - Website

Click on Website. Click on the last (bottom) choice, ASP.NET Configuration

This will open a web page where you can setup security roles and apply them to users.

Rick

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

   SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'

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

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

   SELECT UserId FROM aspnet_Users WHERE UserName = '<username>'

   Replace <username> 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 3. Click Reset.

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

   INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('<roleID>', '<userID>')

   Replace <roleID> with the return value from step 1. Replace <userID> with the return value from step 2. Retain the single quotation marks around these values. Click Submit.

If you have access to the stored procedures, you can run the following in query manger;

exec aspnet_UsersInRoles_AddUsersToRoles '/','John Doe','Administrator','1/28/2006 6:17:30 PM'

The parameters are ApplicationName, UserName, RoleName,  CurrentTimeUtc