Scheduling Jobs - Credentials

[shl007]

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?

[shl007]

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

[SuryaKiran]

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.

[shl007]

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

[SuryaKiran]

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. 

[shl007]

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.

[shl007]

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?

[SASKiwi]

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.

[shl007]

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

[SASKiwi]

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.