Availabilty Group Definition

GlynLamb

I have recently tried to define a connection in SQL Monitor 4 to a Windows cluster running SQL Server 2012 with availability groups.
The connection using the Windows cluster name is successful and attaches to the nodes however it doesn't locate the SQL Server Instances.

I removed this connection and connected to each individual node and it was successful and locates the SQL Server Instances.

So my question is ;
Should I be defining the connect by the Windows Cluster name of the individual nodes.

thanks in advance

Evan Moss

Hello,

Thanks for your post.

Connecting to SQL instances on an availability group shouldn't be a problem for SQL Monitor -- you should be able to use <windowsclustername>* as the address. Is that what you were trying?

If that doesn't work, can you try adding <windowsclustername><sqlinstance1>, then <windowsclustername><sqlinstance2>, etc.?

Please let me know how that goes.

Regards,
Evan

Evan Moss

Hello,

After doing a bit more research and testing, it actually appears the only way to do this is to add each node individually. Sorry about the inconvenience.

Thanks,
Evan

GlynLamb

Evan,
Thanks for the reply.
I will leave it as it is, one for each node.
Just thought it might work like other cluster definitions and pick up everything in the group.

Glyn