Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# SQL Server Always On

iProcess Engine now supports Always On feature for SQL Server. This fail-over mechanism enables iProcess Engine to automatically connect to a secondary database server in case the primary database server fails. For more information about SQL Server Always On, see Always On Availability Groups in SQL Server 2017 documentation.

To use this feature for iProcess Engine, perform the following steps to clone database login information for iProcess Engine from the primary database server to a secondary database server.

| 1. | Run the `SQLAlwaysOn_CloneLogins.ps1` script located in $SWDIR\util in Windows PowerShell.

| 2. | When prompted for, enter the primary server name.

| 3. | Then, enter the login name that you want to clone to the secondary server.

| 4. | Then, enter the secondary server IP. A Windows PowerShell credential request dialog box will be displayed.

| 5. | Enter the user name and password to authenticate the connection to the secondary server. The login information will be cloned from the primary server to the secondary server.

Note | For this feature to work correctly, you must clone both the foreground and the background users.

Note | If you have multiple secondary servers, you must clone login information to each secondary server separately.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.