MSSQL database high availability for MES SAP application

[former_member434198]

Hi all,

We are planning to implement HA/DR for our MES SAP application. Our ODS and WIP databases are based on MSSQL server 2012.

I need to understand how application would connect to failover database instance.

DO i need to run CTC wizard everytime after failover?

[luisdarui]

If you're planing AlwaysOn for example, for JAVA systems (requires JDBC 4.0 or higher), in the connection string have a parameter named "MultiSubnetFailover=YES" that the application server will connect again to SQL Server after a failover, without having to restart the application server.

I suggest going through the entire blog series to understand the AlwaysOn concept:

https://blogs.msdn.microsoft.com/saponsqlserver/2015/10/23/sql-server-alwayson-summary/

PS: it would be a good idea to check with SAP Product Support for SAP MII and SAP ME whether they will support it. For SAP NetWeaver-based applications, check SAP Note 1772688.