I don't remeber admin user.

Oct 14, 2011 at 1:30 PM

Hello! I did install the uManage, but i don't remeber which user is administrator. Can I change the admin user? Where?

Oct 15, 2011 at 7:16 PM

This worked for me:

I execute the follow SQL Query:

DECLARE @RC int
DECLARE @ApplicationName nvarchar(256)
DECLARE @UserNames nvarchar(4000)
DECLARE @RoleNames nvarchar(4000)
DECLARE @CurrentTimeUtc datetime

-- TODO: Specify the user account here
SET @UserNames = N'<DOMAIN\user>'


SET @ApplicationName = N'uManage'
SET @RoleNames = N'Admin,System'
SET @CurrentTimeUtc = GETUTCDATE()

EXECUTE @RC = [uManage-family].[dbo].[aspnet_UsersInRoles_AddUsersToRoles]
   @ApplicationName
  ,@UserNames
  ,@RoleNames
  ,@CurrentTimeUtc
GO


 Ps.: Change "uManage-family" with "YourDomain" and "<DOMAIN\user>" with "YourDomain\YourUserAdmin".