topic Re: Scheduling Jobs - Credentials in SAS Programming

Scheduling Jobs - Credentials

shl007 — Fri, 04 Jan 2019 19:38:44 GMT

Does anyone know what might be causing SAS Enterprise Guide to prompt for my credentials intermittently? Usually my PC authentication should carry over (no prompts). Occasionally (not all the time) I see prompting like below when opening EG, which is causing my scheduled batch jobs thru Windows Task Scheduler to fail. I've recreated my connection profile in EG. Any other suggestions to check/try?

Re: Scheduling Jobs - Credentials

shl007 — Fri, 04 Jan 2019 19:39:13 GMT

I've also made sure my password is saved in my EG profile.

Re: Scheduling Jobs - Credentials

SuryaKiran — Fri, 04 Jan 2019 20:26:32 GMT

You might encounter this usually when the password is changed. Initially it will save with user and its password provided when setting up the profile, later when the password is changed then this prompt appears and you need to provide the new password.

Re: Scheduling Jobs - Credentials

shl007 — Fri, 04 Jan 2019 21:27:29 GMT

Strange, I've changed my password a while ago. Is there any way to tell that my profile is working? The only thing I thought of is scheduling a test run in batch mode. Which I've done.

Thanks

Re: Scheduling Jobs - Credentials

SuryaKiran — Fri, 04 Jan 2019 21:36:19 GMT

If the password is right then the popup will disappear, if not it popup again until it validates for the right one. Do you have SAS EG, you can check your profile there and try to connect to the server for checking.

Re: Scheduling Jobs - Credentials

shl007 — Fri, 04 Jan 2019 21:48:02 GMT

I just rebooted my PC, ,and I am prompted again. 😞 It seems I have to update the password each time in my profile. Then the password stays. Is there a credentials file I can check? I'm not sure where it is on my C drive.

Re: Scheduling Jobs - Credentials

shl007 — Fri, 04 Jan 2019 22:28:30 GMT

Tried scheduling a batch job and got this error when it tried to execute thru Windows Task Scheduler - even though ad hoc session worked fine (interactively). Any ideas?

Re: Scheduling Jobs - Credentials

SASKiwi — Sat, 05 Jan 2019 02:38:12 GMT

This SAS Note explains where your connection profile is stored by default. I would start by deleting the current one and creating a new one: http://support.sas.com/kb/58/246.html.

Re: Scheduling Jobs - Credentials

shl007 — Sun, 06 Jan 2019 22:25:20 GMT

Thanks for that note. Is there a particular file I should have my IT folks focus on in the directory mentioned in the note? There are various files

Re: Scheduling Jobs - Credentials

SASKiwi — Mon, 07 Jan 2019 01:12:44 GMT

Interestly I was digging into this myself as I have a similar problem problem with my connection profile password corrupting. There is an XML file in the ...\SAS\MetadataServerProfiles folder called ConfigurationVnn where nn refers to your EG version. This file appears to define connection profiles.