Creating Logins for a Secondary Server - Database Reference Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License

The RecreateDBUsersHighSecurity application can add the logins for the database users from the primary server to a secondary server with High Availability Disaster Recovery (HADR) enabled.

Note:

HADR Initialization is not required when using a contained database.

The following default logins will be added:

  • hsi

  • hsicore

  • hsinet

  • viewer

To add these logins to the secondary server, do the following:

  1. Double-click RecreateDBUsersHighSecurity.exe.

    The Recreate Database Users & HADR Initialization window is displayed:

  2. Select the HADR Initialization tab.
  3. From the Primary / Principal Server drop-down list, select the ODBC source for the primary server, from which the logins will be obtained.
  4. From the Secondary / Mirror Server drop-down list, select the ODBC source on the secondary server, to which the logins will be added.
  5. If the ODBC sources were configured to use Windows Authentication and you are using your Windows credentials to authenticate with SQL Server, select the Use Windows NT Authentication check box.
  6. Click Connect.
  7. If you did not select Use Windows NT Authentication, you are prompted to enter user name and password credentials. Enter the User and Password for the account connecting to the database instance and click OK.
  8. Click OK.
    You are prompted to enter user and password credentials for authenticating with the secondary server database instance.
  9. Enter the User and Password credentials for the secondary server.
  10. Click OK.
    When the application successfully connects to the primary and secondary servers, a confirmation message is displayed in the text box.
  11. Click the Create Logins button.
    The application creates the logins on the secondary server. Once the logins are created, a confirmation message is displayed in the text box.