BookmarkSubscribeRSS Feed
shoin
Lapis Lazuli | Level 10

SAS 9.4 TS1 M7 on WIN X64 environment trying to set up using Azure Secret from Keyvault and Azure Service Principal to connect with Synapse via SAS ACCESS/MS SQL SRVR.  The documentation is stale and does not provide any direction.  Has any one successfully set it up or point me to any documentation?

 

TIA

S

2 REPLIES 2
SASKiwi
PROC Star

You are using an uncommon combination of software. Your best bet would be to open a track with SAS Tech Support.

 

Is your SAS/ACCESS software working fine with other SQL Server databases, and it is just getting it set up with Synapse that's the problem? 

 

 

shoin
Lapis Lazuli | Level 10

Thank you for your answer.  It is the limitation currently access/sql server not compatible with principle token and credentials.  We switched to id/pw combo.

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
  • 2 replies
  • 1302 views
  • 1 like
  • 2 in conversation