November 3, 2017 at 1:24 pm
I have a 2 node availability group set up on some azure VMs. As per documentation, I've configured an internal load balancer and created the listener. I can connect to the listener fine when its running on both nodes. I've configuring routing list and urls and double checked them.
This seems the be the only azure specific documentation on read only routing and its basically identical to the typical on prem configuration with the exception of the author using the public endpoint port for his internal load balancer example at the very end.
I'm at a bit of a loss here as nothing seems to connect to the secondary when using appropriate connection strings or flags.
November 7, 2017 at 4:48 am
Jeff Shurak - Friday, November 3, 2017 1:24 PMI have a 2 node availability group set up on some azure VMs. As per documentation, I've configured an internal load balancer and created the listener. I can connect to the listener fine when its running on both nodes. I've configuring routing list and urls and double checked them.This seems the be the only azure specific documentation on read only routing and its basically identical to the typical on prem configuration with the exception of the author using the public endpoint port for his internal load balancer example at the very end.
I'm at a bit of a loss here as nothing seems to connect to the secondary when using appropriate connection strings or flags.
are the secondarys enabled for readonly or readintent access
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
November 7, 2017 at 1:23 pm
Yeah so......you have to specify a database in the connection string. Did not know. This is working.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy