What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

SQL Application intent (Read only) connection string MSSQL allways on

Votes:

0

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

allwayson applicationintent mssql sql

Created on Dec 21, 2022 5:08:12 PM

Last change on Dec 23, 2022 6:15:49 AM by Felix Saure [Paessler Support]



1 Reply

Votes:

0

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://kb.paessler.com/en/topic/79245-how-can-i-propose-new-features-or-sensors-for-prtg

Created on Dec 27, 2022 5:27:11 AM by Jonathan Mena [Paessler Technical Support]




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.