March 16, 2019 at 7:48 am
We have a Always on setup on our server. We use the AG name to connect via SSMS. but its not working now. though I can ping it.
Listener can also connect
Any thoughts on this
March 16, 2019 at 10:25 pm
To connect via the AG name you need a DNS entry for it. In general you don't connect with the AG name, but with the listener name or a CNAME in DNS pointing to the listener or to the instance name.
March 17, 2019 at 9:15 am
Try running a NSLOOKUP against the Listener name. If it returns more than 1 IP address you have Multi-Subnet Failover enabled. Some applications cannot use this feature or it must be enabled.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply