Chat now with support
Chat with Support

Active Roles 8.1.4 - Administration Guide

Introduction Getting started with Active Roles Configuring rule-based administrative views Configuring role-based administration Rule-based autoprovisioning and deprovisioning
Provisioning Policy Objects Deprovisioning Policy Objects How Policy Objects work Policy Object management tasks Policy configuration tasks
Property Generation and Validation User Logon Name Generation Group Membership AutoProvisioning Exchange Mailbox AutoProvisioning AutoProvisioning in SaaS products OneDrive Provisioning Home Folder AutoProvisioning Script Execution Microsoft 365 and Azure Tenant Selection E-mail Alias Generation User Account Deprovisioning Office 365 Licenses Retention Group Membership Removal Exchange Mailbox Deprovisioning Home Folder Deprovisioning User Account Relocation User Account Permanent Deletion Group Object Deprovisioning Group Object Relocation Group Object Permanent Deletion Notification Distribution Report Distribution
Deployment considerations Checking for policy compliance Deprovisioning users or groups Restoring deprovisioned users or groups Container Deletion Prevention policy Picture management rules Policy extensions
Using rule-based and role-based tools for granular administration Workflows
Key workflow features and definitions About workflow processes Workflow processing overview Workflow activities overview Configuring a workflow
Creating a workflow definition for a workflow Configuring workflow start conditions Configuring workflow parameters Adding activities to a workflow Configuring an Approval activity Configuring a Notification activity Configuring a Script activity Configuring an If-Else activity Configuring a Stop/Break activity Configuring an Add Report Section activity Configuring a Search activity Configuring CRUD activities Configuring a Save Object Properties activity Configuring a Modify Requested Changes activity Enabling or disabling an activity Enabling or disabling a workflow Using the initialization script
Approval workflow Email-based approval Automation workflow Activity extensions
Temporal Group Memberships Group Family Dynamic groups Active Roles Reporting Management History Entitlement profile Recycle Bin AD LDS data management One Identity Starling Join and configuration through Active Roles Managing One Identity Starling Connect Configuring linked mailboxes with Exchange Resource Forest Management Configuring remote mailboxes for on-premises users Migrating Active Roles configuration with the Configuration Transfer Wizard Managing Skype for Business Server with Active Roles
About Skype for Business Server User Management Active Directory topologies supported by Skype for Business Server User Management User Management policy for Skype for Business Server User Management Master Account Management policy for Skype for Business Server User Management Access Templates for Skype for Business Server Configuring the Skype for Business Server User Management feature Managing Skype for Business Server users
Exchanging provisioning information with Active Roles SPML Provider Monitoring Active Roles with Management Pack for SCOM Configuring Active Roles for AWS Managed Microsoft AD Azure AD, Microsoft 365, and Exchange Online Management
Configuring Active Roles to manage Hybrid AD objects Unified provisioning policy for Azure M365 Tenant Selection, Microsoft 365 License Selection, Microsoft 365 Roles Selection, and OneDrive provisioning Changes to Active Roles policies for cloud-only Azure objects
Managing the configuration of Active Roles
Connecting to the Administration Service Managed domains Using unmanaged domains Evaluating product usage Creating and using virtual attributes Examining client sessions Monitoring performance Customizing the Console Using Configuration Center Changing the Active Roles Admin account Enabling or disabling diagnostic logs Active Roles Log Viewer
SQL Server replication Using regular expressions Administrative Template Configuring federated authentication Communication ports Active Roles and supported Azure environments Integrating Active Roles with other products and services Active Roles Language Pack Active Roles Diagnostic Tools Active Roles Add-on Manager

Viewing database connection settings

The most common reasons for replication problems are access failures that Replication Agents encounter when attempting to connect to the Publisher or Subscriber SQL Server. The security credentials of the Replication Agents depend on the authentication mode of the Administration Service. To determine which authentication mode is actually used: Windows authentication or SQL Server authentication, view the Administration Service database connection settings.

To view connection settings in the Active Roles Console:

  1. In the Console tree, select Configuration > Server Configuration > Administration Services.

  2. In the details pane, right-click the Administration Service you want to view, and click Properties.

  3. In the Properties dialog, go to the Configuration Database tab.

The Configuration Database tab displays the following information:

  • SQL Server: Identifies the SQL Server instance that is used by the Administration Service.

  • Database: The name of the Administration Service database.

  • Use Windows authentication: When this is selected, it indicates that the Administration Service uses Windows authentication mode when connecting to SQL Server.

  • Use SQL Server authentication: When this is selected, it indicates that the Administration Service uses SQL Server authentication mode when connecting to SQL Server.

  • Login name: The name of the SQL Server login that the Administration Service uses to access SQL Server. This only applies to the Use SQL Server authentication option.

Modifying database connection settings

You might have to modify Administration Service database connection settings if the login of the Administration Service for SQL Server authentication is no longer valid, or has the password changed. If you change the login, you also need to change it for Replication Agents, as described in Modifying Replication Agent credentials.

You can modify connection settings by using Active Roles Configuration Center.

To modify the connection settings

  1. Start Configuration Center on the computer running the Administration Service, or connect Configuration Center to that computer.

    You can start Configuration Center by selecting Active Roles 8.1.4 Configuration Center on the Apps page or Start menu, depending upon the version of your Windows operating system. For more information, see Running Configuration Center.

  2. In the Configuration Center main window on the Dashboard page, in the Administration Service area, click Manage Settings.

  3. On the Administration Service page that opens, in the Active Roles database area, click Change.

  4. To view or change the login or password of the Administration Service for SQL Server authentication, use the Change Active Roles Database wizard that appears: Type the appropriate login name and password in the fields under the SQL Server authentication option on the Connection to Database page.

Changing the service account

With the Windows authentication option selected for database connection, the Administration Service uses its service account to authenticate with SQL Server. Additionally, if the Administration Service’s database server holds the Publisher role, and has a Subscriber with Windows authentication, the service account requires the appropriate permissions on the Subscriber SQL Server. For details, see the “SQL Server permissions” section in the Active Roles Quick Start Guide.

Because of the requirements of the service account, you might have to specify a different service account with sufficient SQL Server permissions. Also, you might have to change the service account’s password.

To view or change the service account by using Active Roles Configuration Center

  1. Start the Configuration Center on the computer running the Administration Service, or connect the Configuration Center to that computer.

    You can start Configuration Center by selecting Active Roles 8.1.4 Configuration Center on the Apps page or Start menu, depending upon the version of your Windows operating system. For more information, see Running Configuration Center.

  2. On the Dashboard page in the Configuration Center main window, click Manage Settings in the Administration Service area.

  3. On the Administration Service page that opens, click Change in the Service account area.

  4. On the Change Service Account page that appears, type the logon name and password of the service account, and then click Change.

Changing the SQL Server Agent logon account

If the Publisher has a Subscriber that uses Windows authentication, the SQL Server Agent logon account on the Publisher SQL Server must have appropriate access permissions on the Subscriber SQL Server. For details, see the “SQL Server permissions” section in the Active Roles Quick Start Guide.

Because of these requirements of the SQL Server Agent logon account, there might be a case where you have to specify a different logon account with sufficient access permissions. You might also have to change the password of the logon account. This section provides instructions on how to change the SQL Server Agent logon account.

To specify the name and password of the SQL Server Agent logon account by using SQL Server Configuration Manager

  1. On the computer running the Publisher SQL Server, open SQL Server Configuration Manager.

  2. In the Console tree, select SQL Server Services.

  3. In the Details pane, right-click the SQL Server Agent to modify, and then click Properties.

  4. On the Log On tab, click This account, and specify the account name and password.

  5. Click OK.

  6. For the changes to take effect, click Yes in the confirmation message box.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating