Updating MAS connection string via sas-admin CLI or sas-bootstrap-config

bugraduman1 — Fri, 04 Jul 2025 11:16:31 GMT

Hey Everyone,

We need to update our MAS connection string without logging in to environment manager and of course not logging into even server. So I wrote playbook which retrieves password from vault, decode it , changes related uid``s password in existing connection string. However, I am having difficulties to write this updated string into MAS properties I am using sas-bootstrap-config kv read command to read the value and tried kv write command to write it back and it appears sas-bootstrap-config kv write command does not work at all cause it does not show any error but also it does not update the value. Does anyone know how to update the value of sas.microanalyticservice.properties connnection string value using sas admin CLI ? we are using sas viya 3.5

Thanks in advance

Re: Updating MAS connection string via sas-admin CLI or sas-bootstrap-config

gwootton — Mon, 07 Jul 2025 20:07:02 GMT

If the configuration you are trying to change is available in SAS Environment Manager, you should also be able to update it with the sas-admin CLI's configuration plugin. If you were to update the SAS Configuration Server directly through sas-bootstrap-config, your new value would likely be overwritten by the configuration service where the old value is present.

This blog explains how you could pull down a configuration to a file, modify the file, and push it back to the configuration service:
https://blogs.sas.com/content/sgf/2018/06/08/saving-and-reloading-sas-viya-configuration/

I wanted to say all that before addressing the behavior that sas-bootstrap-config did not update a key. For sas-bootstrap-config kv write to work on an existing key, you need to use the --force option. But again in your case you would not want to use sas-bootstrap-config as the parameter is defined through the configuration service, which would overwrite what was written by sas-bootstrap-config.

topic Updating MAS connection string via sas-admin CLI or sas-bootstrap-config in Administration and Deployment

Updating MAS connection string via sas-admin CLI or sas-bootstrap-config

Re: Updating MAS connection string via sas-admin CLI or sas-bootstrap-config