By default, the installer assigns the local Administrator group to the System Administrator Role in Discovery Center.
During the installation process, the user has the option to choose a different user or group, and can select one of two role options:
- System Administrator role only
- All Active Navigation roles
If you cannot access the system as a member of this group or user, then this script can be used to enable access for additional users
Resolution
Run the version of the attached script that is appropriate for your installation. The specified user or group is added to the database to give access to the following Active Navigation roles.
System Administrator
AN Administrator
Information Manager
Reviewer
To run the script, modify the two lines mentioned below within the script, and then execute it against the Active Navigation database using SQL Server Management Studio.
Specify either a User or a Group to be added to the Discovery Center Database in the form of DOMAIN\USERNAME.
DECLARE @userOrGroupName VARCHAR(MAX) = 'DOMAIN\UserOrGroup'
Leave the value as 1 to add a user, change the value to 0 to add a group.
DECLARE @isUser BIT = 1