Tag Archives: sp_configure output changed after failover

SQL Server properties changed on cluster resource failover

One of my friend has recently had an issue on one of his SQL Server two node cluster. He was seeing different authentication modes for SQL Server depending on which node of the 2-node cluster that it was online on. The only recent change to their SQL Server environment was that they applied Service Pack [...]