MSSQL Server Connections: specifying connection options such as ApplicationIntent=ReadOnly and TrustServerCertificate

Grafana Configuration
1

We have just installed Grafana, and are looking to use it for some dashboarding from SQL Server data. Our SQL Server setup is an Availability Group with read only routing, and as such I would like to configure Grafana to use the readable secondary by specifying ApplicationIntent=ReadOnly in the connection string. However, I cannot see anywhere in the setup for MSSQL Server to do this?

In addition, there is an option to encrypt the connection string, but not to add in TrustServerCertificate, is this something that can be done?

2

Already found a workaround, if you inject it into the servername field, the connection string parameters are considered.

So:-

[servername];ApplicationIntent=ReadOnly;TrustServerCertificate=True;

and so on.