https://communities.sas.com/t5/Administration-and-Deployment/OLEDB-connection-with-option-ApplicationIntent-READONLY/m-p/547911#M15987 <P>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.&nbsp; &nbsp;</P><P>&nbsp;</P><P>This are the connection strings we tried: ("Integrated Security"=SSPI "Persist Security Info"=True "Initial Catalog"=IBZ_MSCRM "ApplicationIntent"=READONLY)&nbsp;</P><P>&nbsp;</P><P>And:&nbsp;("Integrated Security"=SSPI "Persist Security Info"=True "Initial Catalog"=IBZ_MSCRM "Application Intent"=READONLY)&nbsp;</P><P>&nbsp;</P><P>Both string are connecting to the primary node not to the secondary.&nbsp;</P><P>&nbsp;</P><P>I hope someone can help me with this problem.&nbsp;</P> Tue, 02 Apr 2019 14:40:06 GMT MaxBeijer 2019-04-02T14:40:06Z https://communities.sas.com/t5/Administration-and-Deployment/OLEDB-connection-with-option-ApplicationIntent-READONLY/m-p/547911#M15987 <P>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.&nbsp; &nbsp;</P><P>&nbsp;</P><P>This are the connection strings we tried: ("Integrated Security"=SSPI "Persist Security Info"=True "Initial Catalog"=IBZ_MSCRM "ApplicationIntent"=READONLY)&nbsp;</P><P>&nbsp;</P><P>And:&nbsp;("Integrated Security"=SSPI "Persist Security Info"=True "Initial Catalog"=IBZ_MSCRM "Application Intent"=READONLY)&nbsp;</P><P>&nbsp;</P><P>Both string are connecting to the primary node not to the secondary.&nbsp;</P><P>&nbsp;</P><P>I hope someone can help me with this problem.&nbsp;</P> Tue, 02 Apr 2019 14:40:06 GMT https://communities.sas.com/t5/Administration-and-Deployment/OLEDB-connection-with-option-ApplicationIntent-READONLY/m-p/547911#M15987 MaxBeijer 2019-04-02T14:40:06Z https://communities.sas.com/t5/Administration-and-Deployment/OLEDB-connection-with-option-ApplicationIntent-READONLY/m-p/879171#M26755 <P>Did you ever figure this out? Having a similar issue.</P> Sat, 03 Jun 2023 17:54:30 GMT https://communities.sas.com/t5/Administration-and-Deployment/OLEDB-connection-with-option-ApplicationIntent-READONLY/m-p/879171#M26755 Mike_B 2023-06-03T17:54:30Z