I saw in several situations that our customers are trying to use applicationIntent=Readonly parameter in their connectionstring, but, I would like to mention that this only applies when you have available and enabled ReadScale in Business Critical, HyperScale or Premium database tier.
If you using ApplicationIntent=ReadOnly for database tiers, like basic, standard or general purpose the connection will be possible, but, instead of connecting to the read only replica will be directly to the primary one in readwrite model.
Enjoy!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.