changing active profile password in VB script?

[jay_q]

Hello all,

I'm wondering if there's any way I can change active profile password for SAS EG in a Excel VBA UI. My company policy requires to change password for sasapp server every few month. Could I impliment the change in a vb script? I notice in the current SAS.EG.Scripting, there's no password property selection under ISASEGProfile members.

Thanks for any help in advance

Lei

[ChrisHemedinger · Accepted solution]

No, there isn't a script method to change these credentials. 

The profile information is maintained in %appdata%\SAS\MetadataServerProfiles\ConfigurationVnn.xml – for each version of EG that you run.  It probably wouldn't be too difficult to write a script that augments/changes that file, which is simple XML – though SAS does not document the format or support modifying it "by hand".

Chris