We have setup a 2 node Synchronous AG with automatic failover to provide HA for our ERP application (Dynamics GP)
The GP desktop client loads a number of shared reports and dictionaries from a file share currently located on one of the database servers. In order to provide complete high availability this share needs to be available in the event of a failure of the primary replica.
At first I thought I would just copy the folder and setup shares on the secondary replica but realized SMB is not accessible through the AG listener.
My second thought was to move the share to another location however this still introduces a single point of failure and defeats the purpose of HA.
My only 2 real choices are to somehow add the folder as a resource to the cluster, however the 2 nodes are virtual machines and creating a shared SAN disk would be complex
Or a messier option would be to create a task that checks the server name and in the event of a failover would update DNS to direct clients via UNC to the correct server share.
What would be the recommended approach for this?