SQL Application intent (Read only) connection string MSSQL allways on
Modified on 2025-06-10 16:50:33 +0200
Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.
Important: We no longer maintain this article. The information might be out of date.
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
Disclaimer:
The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.
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