Can someone please let me know how I can go about giving myself admin rights to my site.I recently uploaded my site to the server, and I have an spl 2005 database. The site works like a charm, but I don't know how to assign myself admin rights so that
I can have control of the site......any help would be appreciated.
1.Go to your Query Analyzer2.Input-
SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"3.Copy bracketed response into a text document and include the brackets4.
Reset QA and Input- SELECT UserId FROM aspnet_Users WHERE UserName="username"- Copy each bracketed response to your text document.- Reset QA again and Input- INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES (paste the roleID and UserID in here)
ramelllamar
0 Points
15 Posts
How do I give myself Admin rights to my site
Jul 26, 2008 04:38 AM|LINK
Can someone please let me know how I can go about giving myself admin rights to my site.I recently uploaded my site to the server, and I have an spl 2005 database. The site works like a charm, but I don't know how to assign myself admin rights so that I can have control of the site......any help would be appreciated.
zowens
Member
693 Points
243 Posts
Re: How do I give myself Admin rights to my site
Jul 26, 2008 04:11 PM|LINK
Open the "ASP.NET Administration" tool and add yourself to the "Administrators" role.
Coordinator for the ClubStarterKit (Open Source)
http://codeplex.com/clubstarterkit
phamster
Member
107 Points
342 Posts
Re: How do I give myself Admin rights to my site
Aug 07, 2008 08:00 PM|LINK