topic Re: SAS ACCESS/MS SQL SRVR & Azure Secret from Keyvault for Synapse in Administration and Deployment

SAS ACCESS/MS SQL SRVR & Azure Secret from Keyvault for Synapse

shoin — Thu, 02 Mar 2023 20:55:23 GMT

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

Re: SAS ACCESS/MS SQL SRVR & Azure Secret from Keyvault for Synapse

SASKiwi — Thu, 02 Mar 2023 21:33:18 GMT

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?

Re: SAS ACCESS/MS SQL SRVR & Azure Secret from Keyvault for Synapse

shoin — Thu, 23 Mar 2023 15:53:14 GMT

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.