I have the following scenario: 2 database servers SQL Server 2008 R2 on Windows server 2012 R2, Cluster 2 nodes (with no-shared storage), with different Server Collation settings, planning to implement an AG after upgrade SQL Server to 2014 SP2.
Will that different Server Collation settings have an impact on implementing the AG? Or will it affect the SQL Failover operation if required to be done?
Note: this structure is still in the testing phase.