I'm a Little confused about this topic.
I know with a default instance, we can create a cluster with let's say, with the ip x.x.x.10. then automatically this IP will connect to the x.x.x.9 that is the principal. if the principal is down, it will connect to x.x.x.8 that is the secondary.
How does this work if I have a named instance? I'm having a problem that I create both instances
X.X.X.37\SQLBACKUP. I'm trying to connect via SSMS to the X.X.X.38 That is the CLUSTERs Ip but It shows the error that the instance cannot be found. Normally with a non named instance, using that cluster IP, it points to the primary SLQ instance on that cluster.
listener have this job here? I think I quiet not understand it's purpose.