We are having issues with Vault authentication with SQL always on feature.
When we configure IP for the Main DB Server (This has two DBs, one main and the secondary) in vault’s config.json., it works But when we configure the FQDN (This is the FQDNs for the SQL Always On Alias.), it fails to authenticate.
Then we understood that
- FQDN in config.json of vault will work only if using SQL authentication.
- Vault has limitation in Windows Authentication and requires to use IP in that case.
Can anyone let us know is it possible to configure vault with SQL Always On Alias. If yes please let us know the steps.