As Enterprise Analyzer (EA) supports Microsoft SQL Server, can EA be used in their High Availability Environment and if so, how do you configure EA?
This article is applicable to Enterprise Analyzer 7.0 and above
Within the High Availability MS SQL Server environment, there are two main ways to connect to the database. These are:
In both cases, there is another option that needs to be set and that is the MultiSubnetFailover connection option.
Connection parameters for the AOAG Listener
When specifying the server name as part of the connection information, this now needs to be changed as follows:
An example with the listener name SQLLsnr on the default port
An example with the listener name SQLLsnr on port 1440
Extra MultiSubnetFailover connection option
To be able to successfully use EA within the MS SQL High Availability environment, an extra connection option MultiSubnetFailover needs to be turned on.
With the release of EA 7.0 Hot Fix 2, there is now a new option for enabling MultiSubnetFailover for SQL Server workspaces that has been added to the create workspace dialog.
Micro Focus Community Manager
If you find this post useful, give it a ‘Like’ or use ‘Verify Answer’