BookmarkSubscribeRSS Feed
MaxBeijer
Fluorite | Level 6

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. 

1 REPLY 1
Mike_B
Obsidian | Level 7

Did you ever figure this out? Having a similar issue.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1406 views
  • 0 likes
  • 2 in conversation