We have a OLEDB connection string to a clustered sql server where we want to connect to a readable secondary node with the option ApplicationIntent=READONLY. We tried to add the option in the OleDB connection Information Options in SMC.
This are the connection strings we tried: ("Integrated Security"=SSPI "Persist Security Info"=True "Initial Catalog"=IBZ_MSCRM "ApplicationIntent"=READONLY)
And: ("Integrated Security"=SSPI "Persist Security Info"=True "Initial Catalog"=IBZ_MSCRM "Application Intent"=READONLY)
Both string are connecting to the primary node not to the secondary.
I hope someone can help me with this problem.