Hello Nikhil,
When you talk about Microsoft SQL Server with HA I suppose you have a listener.
From my experience using Microsoft SQL Server with HA you must setup the datasource to use the listener itself.
By doing that when the listener is switched over to different server ACE won't even notice that. For example between primary and disaster center.
------------------------------
Petar Petrov
------------------------------