How to configure SQL Always On with AuthAnvil Database Users

Note: This process will not update the connection used by SSO. If you are using SSO v4.5- newer as well please do not use this process.

Changing the AADBUser Password:

Note: This utility will only function in versions 5.0 and 5.5 and there must also exist a "AuthAnvil Setup V5.0" folder in C:\Program Files\Scorpion Software before it will work. If it is not there just create it.

Note: If the password for the AADBUser is changed manually without using the specified utility, the connection string will be broken therefore resulting in the product not functioning.

Steps to change AADBUser Password:

1. Manually change the password in SQL under Security > Logins.
2. Run the "AuthAnvil2FA_DBMigrationTool.exe" located in "C:\Program Files\Scorpion Software\AuthAnvil\AuthAnvilTools" and enter the password you previously set manually in SQL in the "New" and "Confirm" password
3. Set the SQL Instance name in the "AuthAnvil2FA_DBMigrationTool.exe" utility
4. Select the "Set New DB Info" button.

Changing the AAPSUser Password:

Steps:

1. Change the Password in SQL for the AAPSUser (write it down as it will be required).
2. Browse to C:\Program Files\Scorpion Software\AuthAnvil Password Server\Tools and open a command prompt here.
3. On the command prompt, type in ProtectConfig.exe -u "C:\Program Files\Scorpion Software\AuthAnvil Password Server\AAPS\Web.config" and press enter.
   What this will do is take the encrypted connection string in the web.config file, and decrypt it, revealing the password in plain text.)
4. Find the line for the connection string which starts with <add name="AuthAnvilPasswordServer" connectionString="Data Source=" and scroll to the right until you find the "User ID=AAPSUser;Password=" area. Replace the text password after the equals sign with the password you entered into the SQL DB for the AAPSUser.
5. Save the web.config file and close it.
6. In the command line, change the " -u" to be a "-p" so the line looks like this before you press enter C:\Program Files\Scorpion Software\AuthAnvil Password Server\Tools>ProtectConfig.exe -p "C:\Program Files\Scorpion Software\AuthAnvil Password Server\AAPS\Web.config"
7. Press enter and wait until the command has completed.
8. Test the connection to PWS by trying to log in.

Full Command prompt value when all above steps are completed will be the following: (minus the <press Enter> line items.
C:\Program Files\Scorpion Software\AuthAnvil Password Server\Tools>ProtectConfig.exe -u "C:\Program Files\Scorpion Software\AuthAnvil Password Server\AAPS\Web.config"

<Press Enter>

Loading Config.
Config Loaded.
Section unprotected.

C:\Program Files\Scorpion Software\AuthAnvil Password Server\Tools>ProtectConfig.exe -p "C:\Program Files\Scorpion Software\AuthAnvil Password Server\AAPS\Web.config"

<Press Enter>

Loading Config.
Config Loaded.
Setting connection certificate
Saved the certificate information to the config file.
Config Reloaded.
Config file protected with custom provider

C:\Program Files\Scorpion Software\AuthAnvil Password Server\Tools>

This will reconfigure the connection string to use the new password, and the password can then be added to both SQL instances as desired.

Questions?

If you have any questions or need some help, we would be happy to assist. Open a case at help.scorpionsoft.com or send an email to support@scorpionsoft.com.