To turn a regular user into an admin user you need to make him member of the Administrators role.
You need to lookup userid from Users table. Assuming the PortalID of your website is 0, the statement would be:

DECLARE @UserID = {enter your userID here};
INSERT INTO UserRoles (UserID, RoleID, Status, isOwner, ExpiryDate, EffectiveDate, IsTrialUsed, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate)
SELECT @UserID, RoleID, 1, 0, Null, Null, 1, -1, getDate(), -1, GetDate() FROM Roles WHERE PortalID = 0 AND RoleName Like N'Administrators';

You need to restart your DNN website for this change to become effective.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

nothing.... I do like you said me...

DECLARE @UserID INT = 2;

INSERT INTO UserRoles (UserID, RoleID, Status, isOwner, ExpiryDate, EffectiveDate, IsTrialUsed, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate)

SELECT @UserID, RoleID, 1, 0, Null, Null, 1, -1, getDate(), -1, GetDate() FROM Roles WHERE PortalID = 0 AND RoleName Like N'Administrators';

-------------------------------------------

Now when i try to login with user Admin said me again the problem and not let me go to panel Admin...

http://guijarroconsultores.com/Default.aspx?tabid=92&error=An%20unexpected%20error%20has%20occurred&content=0

 I am so angryyyy i need help because i can´t to do something like créate more module or write more inside.

 

I don´t know if this is a problem... said tabid=92... i search in table tabmoduleid and i see that tabid92 is bannerpanel, i copy/paste this row here.

TabModuleID TabID ModuleID PaneName ModuleOrder CacheTime Alignment Color Border IconFile Visibility ContainerSrc DisplayTitle DisplayPrint DisplaySyndicate IsWebSlice WebSliceTitle WebSliceExpiryDate WebSliceTTL CreatedByUserID CreatedOnDate LastModifiedByUserID LastModifiedOnDate IsDeleted CacheMethod ModuleTitle Header Footer CultureCode UniqueId VersionGuid DefaultLanguageGuid LocalizedVersionGuid
110 92 421 BannerPane 1 1200 NULL NULL NULL NULL 0 NULL 0 0 0 0  NULL 0 1 2015-09-24 12:42:15.090 1 2016-01-08 12:59:27.463 0 MemoryModuleCachingProvider despacho abogados granada, administradores fincas y asesoría fiscal laboral en granada NULL NULL  0C8BDC7D-0B6A-4F3A-87B4-21317CCF0450 945D4E6E-AB35-4C2D-8AE3-B24A7AA98F79 NULL 701793CF-F8CC-407E-B2A2-ED16EA9BA2BC

 

the login itself succeeded, but loading the user data afterwards seem to fail. this might be caused by different user profile properties of host users versus all other users.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN