ADD SUPPORT FOR SQL ALWAYS ON
PLEASE ADD SUPPORT TO CONNECT THE SQL TO AN SQL ALWAYS ON MIRROR FARM. IN THIS CONFIGURATION, INSTEAD OF POINTING TO A SPECIFIC INSTANCE IN SQL, THE CONNECTION STRING NEEDS TO POINT TO A TCP AVAILABILITY GROUP ( A CLUSTERED IP ADDRESS). FOR EXAMPLE: ON THE CONNECITON STRING, INSTEAD OF USING
DataSource = SQL2012-VS1\SQL;
I would use
Data Source=TCP:SQL-AG1;
Please contact me and I would be happy to discuss
1
vote
Anonymous
shared this idea