DB read only replica

Question

I want to connect to the Database read replica. From the documentation I found that to connect to a read replica DB, we need to pass ApplicationIntent=ReadOnly in the conncetion string.
I am using Sequelize library to make DB connection(mssql), but I am not getting where I need to pass ApplicationIntent=ReadOnly in the connection using Sequelize (in node js).

Answer 1

Hello @Agashe, Prateek Thank you for being patient while working on this.
You can use ApplicationIntent=ReadOnly in the connection string in SSMS. You can use the Login UI in SSMS or ADS to specify server/database/login name, and then add ApplicationIntent=ReadOnly in the additional parameters box, or in the corresponding place in ADS From SSMS, you can pass the parameter under additional connection properties as below: Please refer to this documentation for more details.

Hope that helps. Please let me know the result.
Accept answer if that helps so it can be beneficial for other communities members with similar issues.

Regards,
Oury