ConnectionString parameter with HeidSQL?

Lordas posted 3 years ago in Creating a connection

Hi together,

is it possible to set a connectionstring parameter to connect to a sql database with heidisql? In my case I need the "ApplicationIntent=ReadOnly" paraemter.

Is this possible? I did not found any parameter field at connection manager.

Thank you in adavance.

ansgar posted 3 years ago

No, HeidiSQL has all supported parameters in the session manager with their own control. Connection strings in HeidiSQL are for MSSQL only, so I guess you are on MSSQL?

Lordas posted 3 years ago

Hi ansgar,

yes I'm on a mssql 2014 server with AlwaysOn cluster. So I need the ApplicationIntent parameter for the connection to the reporting node of the cluster.

Please login to leave a reply, or register at first.