Chat now with support
Chat with Support

Migrator Pro for Active Directory 20.11.2 - Requirements and Installation Guide

Section 1. Introduction Section 2. Directory Sync Pro Prerequisites Section 3. Directory Sync Pro for Active Directory Advanced Network Requirements Section 4. Migrator Pro for Active Directory Prerequisites Section 5. Requirements for Both Directory Sync Pro for Active Directory and Migrator Pro for Active Directory Section 6. Installing Directory Sync Pro for Active Directory and Migrator Pro for Active Directory Section 7. Upgrading Directory Sync Pro for Active Directory and Migrator Pro for Active Directory Section 8. Modifying, Repairing and Uninstalling Directory Sync Pro for Active Directory and Migrator Pro for Active Directory Section 9. Migrator Pro for Active Directory Agent Installation Section 10. Troubleshooting Appendix A: Configuring Directory Sync Pro for Active Directory in a Non-English Active Directory Environment Appendix B. Installing and Configuring SQL Server Reporting Services Appendix C. STIG Environments Appendix D. Deployment in FIPS Environment

Verifying the Report Server URL

Installing SQL Server Reporting Services

These instructions are for existing SQL Server installs where reporting services are being added.

Migrator Pro for Active Directory reporting is supported on SSRS 2012, 2014, or 2017.

  1. Load the ISO into the DVD drive.

  2. Open My Computer.

  3. Double-click on the DVD drive to run the SQL Server Installation Center dialog.

  4. Select Installation from the left.

  5. Select New installation or add features to an existing installation.

  6. Click the OK button on the Setup Support Rules page if everything passed.

  7. Click the Install button on the SQL Setup Files page.

  8. Click the Next button on the Setup Support Rules page if everything passed.

  9. Select Add features to an existing instance of SQL Server (verify your instance is shown).

  10. Click the Next button.

  11. Check the Reporting Services box and click the Next button.

  12. Click the Next button on Installation Rules.

  13. Click the Next button on Disk Space Requirements.

  14. Click in the Account Name field and select NT AUTHORITY\NETWORK SERVICE.

  15. Click the Next button.

  16. Click the Next button on the Reporting Services Configuration to Install, but do not configure the report server option.

  17. Click the Next button.

  18. Click the Next button on Installation Configuration Rules page if everything passed.

  19. Click the Install button on the Ready to Install page.

  20. If you have a green checkmark on the 'Complete' page, click the Close button.

  21. Close the SQL Server Installation Center dialog.

Configuring SQL Server Reporting Services

  1. Click Start > All Programs > Microsoft SQL Server > Configuration Tools.

  2. Click on Reporting Services Configuration Manager.

  3. Click the Connect button.

  4. Select Service Account from the left.

    1. Verify Network Service is set for the built-in account.

  5. Select Database from the left.

    1. Click the Change Database button.

    2. Verify 'Create a new report server database' is selected and click the Next button.

    3. Set your security type and click the Next button.

    4. Leave the defaults. Verify 'Report Server Mode' is set to 'Native' (Reporting will fail to work if not in Native Mode)

    5. Click the Next button.

    6. Click the Next button.

    7. Click the Next button and it will begin to configure the database.

    8. Click the Finish button.

  6. Select Web Service URL from the left pane.

    1. Click the Apply button.

  7. Select Report Manager URL from the left pane.

    1. Click the Apply button.

  8. Click the Exit button.

Your Report URLs

Browseable URL

http://<servername>/Reports

Or

http://<servername>/Reports_InstanceName (if SQL Server is installed as an instance)

Web Service URL

http://<servername>/ReportServer

Or

http://<servername>/ReportServer_InstanceName (if SQL Server is installed as an instance)

Verifying the Report Server URL

The Report Server URL is needed when installing the Reporting feature. Use the following steps to verify the correct URL to use.

  1. Open Reporting Services Configuration Manager.

  2. Provide the SQL Server Name and Report Server Instance name and click Connect.

    Reporting_Services1

  3. In the left folder navigation, select Web Service URL.

  4. The Report Server URL appears in the Report Server Web Service URLs section.

    Reporting_Services2

 

 

Appendix C. STIG Environments

Please note the following considerations for STIG environments.

SQL Express

The SQL Express option should not be chosen when installing Directory Sync Pro for Active Directory and Migrator Pro for Active Directory. SQL Express does not include the following settings or features needed for STIG environments:

  • SQL Server must be monitored to discover unauthorized changes to stored procedures. (SQL Agents is not part of SQL Express) 41403, 41404, 41405

A dedicated SQL Server (full version) should be used.

SID History

In order for SID History copy to function in a STIG environment, additional security setting changes are needed in GPO on the domain controller. 

By default, Success and failure auditing of account management must enabled for both source and target domains via local security policy or GPO.  However, because “Audit: Force audit policy subcategory settings (Windows Vista or later) to override audit policy category settings” is enabled per STIG policy, additional audit policy settings must be configured for both source and target domains.

To configure the audit policy settings:

  1. Navigate to the "Advanced Audit Configuration" settings in the Default Domain Controllers Policy (Computer Configuration\Policies\Windows Settings\Security Settings\Advanced Audit Policy Configuration\Audit Policies).

  2. Enable all the Subcategories of DS Access (Success) and Account Management (Success, Failure). 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating