Performing an installation of CA Process Automation, up to the point of the database configuration screen, all is moving forward as expected.
Trying to Create or Test the database connection for a new install returns the error message "Test not successful. Please check database settings"
Outside of the installer, connections to the database are all successful.
The solution is to run the installer using "Run as Administrator" on the right click menu.
In the installation.log file there will also be a messages showing:
[ISO_PATH]\drivers\jtds-1.3.1.jar does not exist.
Exception writing file from [ISO_PATH]\drivers\jtds-1.3.1.jar to [INSTALL_PATH]\server\c2o\ext-lib\jtds-1.3.1.jar
[ISO_PATH]\drivers\jtds-1.3.1.jar (The system cannot find the path specified)
net/sourceforge/jtds/jdbc/Driver : Unsupported major.minor version 51.0
It isn't that there is a problem with the connection to the database, it's that there was a problem in copying all the necessary files to the file system.
Even though the user logged on to the server is a member of the Administrator group, the user is not "Administrator" and therefor needs to run the installer using the 'Run as Administrator' menu option.
This is not User Access Control - in fact, even with UAC disabled this can still be a problem.
This problem can also be due to multiple JREs/JDKs installed on the system. Make sure to uninstall all JDKs and JREs except the one used by Process Automation. Then launch the install again.