Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Access Rights Manager (ARM) formerly 8MAN > ARM - Knowledgebase Articles > Change ARM group wizard strategy type

Change ARM group wizard strategy type

Updated October 10, 2018

Overview

This article details how to manipulate your database to change the strategy type to be used for the ARM group configuration wizard, for example, using local groups instead of global groups.

SolarWinds strongly recommends that you back up your database before making any edits to your system database. You should only edit the database if you are experienced and confident in doing so. SolarWinds cannot guarantee resolutions to any corrupt or missing data resulting from making database edits.

Environment

  • Access Rights Manager

Detail

When you first configure the ARM group wizard, you have to choose which group strategy should be used. To prevent errors in configurations, it is not possible to change this selection once set, but occasionally it becomes necessary to change the group strategy, for example, using local groups instead of global groups. In this case, it is necessary to manipulate the database. 

Resolution

  1. Stop the ARM service.
  2. Connect to your database using SQL Server Management Studio.
  3. Backup your database.
  4. Right-click on your ARM database and select "New Query".
  5. Execute the following query:
    SELECT _id FROM dbo._server_configuration_object_values WHERE _property LIKE 'usegroupwizard'
  6. Note the _id value from your result.
  7. Execute one of the following queries to update the group wizard strategy value to reflect the new strategy used:

     

    Strategy Details Query
    UseLocalGroups ARM creates permission groups as domain local security groups UPDATE dbo._server_configuration_object_values SET _value = 'UseLocalGroups, IsValid, RealExecution' WHERE _property LIKE 'groupwizardstrategy' AND _id LIKE 'the result _id from your first query'
    UseGlobalGroups ARM creates permission groups as global security groups UPDATE dbo._server_configuration_object_values SET _value = 'UseGlobalGroups, IsValid, RealExecution' WHERE _property LIKE 'groupwizardstrategy' AND _id LIKE 'the result _id from your first query'
    UseUniversalGroups ARM creates permission groups as universal security groups UPDATE dbo._server_configuration_object_values SET _value = 'UseUniversalGroups, IsValid, RealExecution' WHERE _property LIKE 'groupwizardstrategy' AND _id LIKE 'the result _id from your first query'
    UseLocalAndGlobalGroups ARM creates a domain local permission group as well as a global group and nest them accordingly UPDATE dbo._server_configuration_object_values SET _value = 'UseLocalAndGlobalGroups, IsValid, RealExecution' WHERE _property LIKE 'groupwizardstrategy' AND _id LIKE 'the result _id from your first query'
    CrossDomainHandling ARM creates the global groups in the domain that contains the user objects UPDATE dbo._server_configuration_object_values SET _value = 'UseLocalAndGlobalGroups, CrossDomainHandling, IsValid, RealExecution' WHERE _property LIKE 'groupwizardstrategy' AND _id LIKE 'the result _id from your first query'
  8. Ensure that all old ARM groups are converted to the new strategy type. If old groups are not converted, ARM will create new groups on these folders, resulting in two separate permission groups.
  9. Restart the ARM service.

 

Last modified

Tags

Classifications

Internal Use Only