Would be nice to have a way to add ApplicationIntent=READONLY to the connection string. Maybe in the SQL v2 setting where you can select user application intent. this would modify the connection string to include ApplicationIntent=READONLY E.G. SQL connection string with Application intenet enabled.. 

ODBC;DSN=mydsn;Description=mydesc;Trusted_Connection=Yes;APP=Microsoft Office 2010;DATABASE=mydb;ApplicationIntent=READONLY;;TABLE=dbo.mytable

Or 

Server=tcp:<server>.database.windows.net;Database=<mydatabase>;ApplicationIntent=ReadOnly;User ID=<myLogin>;Password=<myPassword>;Trusted_Connection=False; Encrypt=True;

https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql

Article Comments

We handle the feature requests in our knowledgebase, you can create a new request or vote for a request that has been previously requested. The requests with more votes will get higher priority on our developers department. You can find more information here https://helpdesk.paessler.com/en/support/solutions/articles/76000063572-how-can-i-propose-new-features-or-sensors-for-prtg


Dec, 2022 - Permalink