title: Using ApplicationIntent=ReadOnly with Azure SQL Database Failover group and Primary Connection String
body: <p>I have started using ApplicationIntent=ReadOnly; for Premium Databases which works great.</p>
  
  <p>However if I use the Fail-over group connection then the connection is always READ_WRITE. Can you not use ApplicationIntent=ReadOnly with the main FOG connection string:
  Server=tcp:xxxx-fog.database.windows.net,1433;Persist Security Info=False;Connection Timeout=300;TrustServerCertificate=True;Database=xxx;ApplicationIntent=ReadOnly;</p>
  
  <p>I can use the geo-secondary fine for this - but we already have a lot of load on the geo-secondary, so I wanted to use some of the primary replicas for reading too.</p>