Recreating Database Users - 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

To recreate database users:

  1. Double-click RecreateDBUsersHighSecurity.exe.

    The Recreate Database Users & HADR Initialization window is displayed:

  2. On the Recreate Users tab, select the ODBC data source for your OnBase database from the Data Source drop-down list.
  3. If the ODBC source was 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.
  4. Click Run Script.
  5. 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.

    The application authenticates the provided credentials against the database. Once authentication is complete, the necessary accounts are created.

    Note:

    When using RecreateDBUsersHighSecurity with a SQL Server database instance, if any of the OnBase logins already exist for that instance, the application maps the database users to the SQL Server logins. The appropriate rights are also granted for all OnBase tables.

    When the process is finished, the message Script completed successfully is displayed in the text box.

    Note:

    Database users will not be created when using RecreateDBUsersHighSecurity.exe with a contained database.

  6. Click Exit to close the application.