SQL Server Workgroup Cluster FCM Errors

Background One of the new features of SQL Server 2016 is the ability to use SQL Server with Failover Cluster in a workgroup rather than joined to Active Directory. When working with SQL Server and Failover Clustering in a workgroup, many of the abilities that are normally used with Active Directory are no longer available,…

0

Finding Which Connections Have Been Read Only Routed

This is a follow up to my first post Finding What Availability Group Listeners Applications Are Using To Connect, where a question was posed about knowing which connections have been read only routed. Background Information SQL Server Availability Groups allow for something called “Read Only Routing” which allows for severs that are currently a secondary…

0

Finding What Availability Group Listeners Applications Are Using To Connect

Background Information While on site helping with AlwaysOn Availability Groups, it was tasked to a DBA to meet with all of the application owners and figure out what listener they were currently using in their connection strings. The DBA looked over at me and said, “I wish there was a DMV that showed me connection…

5

Azure RM: SQL Server AlwaysOn Availability Groups Listener configuration with Azure External Load Balancer

I want to thank to Ruben Gonzalez for his guidance.   This blog post explains how to configure SQL Server AlwaysOn AG with an External Listener in Azure VMs running in Resource Manager model. Pre-requisites Before to start ensures that the environment is ready, deploy VMs in Azure RM model: Create a Resource Group. Create a Virtual…