Tag: SSMS
-
Store Optional Connection Parameters in SQL Server Management Studio
About six months ago I wrote about the challenges of using the Always-On Availability Group Listeners with SSMS. At the time, I had presented three problems and only solutions for two of them. At this time, I am happy to announce that Microsoft has responded to our connect ticket and provided a current version work […]
-
Connecting to an Availability Group Listener with SQL Server Management Studio
Background When a cluster has an Availability Group installed on it, there is an optional listener which is used to manage connections through fail-over events. This listener has an IP address assigned to it and, when the Availability Group fails over within the same sub-net, the listener simply comes online on the new node. That node […]