Desktop productivity for business analysts and programmers

SAS EG Connection prompting for credentials every time I open an EG session or project

Reply
Frequent Contributor
Posts: 138

SAS EG Connection prompting for credentials every time I open an EG session or project

Hello,

 

I am currently using EG 6.1.  I have saved my credentials to our server multiple times on the connection profile.  However, each time I open an EG project, it prompts me for the credentials.  Besides the fact that it is annoying to enter them ever time, I have a task scheduled to run a project during the evening and it fails because it is being prompted for the server credentials.  The project itself doesn't even need the server as it runs locally.  What I am finding is that it is all or nothing with EG... if I have a connection set up, it is not at the project level but for all of EG.

 

I am hoping someone can tell me if there is a better way or if I am doing something wrong with the setup under options -> Administration -> Connections.  I save all of the server info and credentials but it doesn't seem to matter.  I also have my credentials persistence set to "Persist for Users" in the security menu.

 

Thanks!

Respected Advisor
Posts: 3,065

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

My guess is your EG connection profile is corrupted and changes to it are not being saved. I suggest you delete your current profile and then try saving it again. Here is a brief explanation of where to find this:

 

Connection profiles are stored in an XML file called ConfigurationVnn.xml (where nn is the SAS Enterprise Guide version number) in the user’s application data area (for example, %appdata%\SAS\MetadataServerProfiles\ConfigurationV61.xml).

 

I'm pretty sure you can find the location of the profile in EG Options.

Frequent Contributor
Posts: 138

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

Thanks @SASKiwi.  I tried what you suggested with no luck.  However, I see what is going on.  I noticed that when I set up the profile and choose "save login info" the box will not remained checked after connecting to the server.  I tried to manually change the xml file to "true" for that flag as well.  When I log into the server that flag is changed back to false.  Could there be some sort of policy on the server that will not allow those credentials to be saved?  If not, I may be out of luck unless you have other suggestions.

 

Bottom line is that this is going to prevent me from scheduling enterprise guide projects to run with task manager because it will prompt for the connection every time.

Community Manager
Posts: 2,697

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

Yes, this behavior is set on the metadata server with the SASSEC_LOCAL_PW_SAVE option.

Frequent Contributor
Posts: 138

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

Thanks Chris. I was afraid of that.

 

 I was actually just reading a couple of your posts trying to figure this out, specifically this one. http://blogs.sas.com/content/sasdummy/2012/04/17/doing-more-with-sas-enterprise-guide-automation/#co...

 

After digging around in the comments of another post, I found this article.


http://support.sas.com/kb/30/917.html

I tried creating this credentials file for EG 6.1, saved a copy in all of the potential locations based off of the older versions in the article but I still have no luck.

If I go into the project and make sure it is set up on a local server where the credentials are not required, it works.  However, it only works IF I don't have another EG project where I have logged into the server.  It seems EG saves the credentials of the last project that was opened.  This is all very puzzling. 

 

Is there another way to work around the setting on the server that will not allow me to save the credentials locally?  I really need to be able to get past this for scheduling to work properly.

 

 

Frequent Contributor
Posts: 138

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

@ChrisHemedinger, not sure if you got the chance to see my reply yesterday.  Do you have any recommendations on ways I can work around this?

Community Manager
Posts: 2,697

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

[ Edited ]

Hey @elwayfan446,

 

I suggest that you work with SAS Tech Support on this.  I recommend that you turn on logging with logging.config, and that will generate some diagnostic logs even when running in automation.  Those logs might help to reveal where EG is looking for (and not finding) credentials.

Occasional Contributor
Posts: 5

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

[ Edited ]

In the folder C:\users\myvunetid\appdata\roaming\sas\metadataserverprofiles

(myvunetid is my vunet-id) there is a file named “configurationV71.xml”

Change the contents to  as follows:

<?xml version="1.0" encoding="utf-8"?>

<Configuration LastWrittenBy="Engine Configuration Manager" FileVersion="2">

  <Profiles>

    <Profile>

      <Name>******</Name>

      <Description>******</Description>

      <Type>OMS</Type>

      <Hosts>

        <Host machine="*****" port="8561" />

      </Hosts>

      <UseIWA>False</UseIWA>

      <SaveLogin>True</SaveLogin>

      <User>******</User>

      <Password>****** </Password>

      <DefaultServer>SASApp</DefaultServer>

    </Profile>

  </Profiles>

  <Settings>

    <ActiveProfile>******</ActiveProfile>

    <GenerateLocalServer>False</GenerateLocalServer>

  </Settings>

</Configuration>

 

Change ****** to real names you would use.

Please use

proc pwencode in='your-password';

run;

to generate encode password like:

{sas002}6FE4B62647E0E59721B8CAD44A12345C

Put the encode word as the password in the xml file.

The most important part is you must set this file (configurationV7.xml)  to read only.

This will prevent the globe policy to update it (which would set user_id and password to space and ask you to key in).

 

This method stored the user_id, password and the active profile name in your local desktop. It would not be changed by your domain policy. You can schedule the project (you must put the active profile name in the configurationV71.xml to let EG directly link to that profile).

 

This may be the only way I can find to schedule the EG project on your desktop if the domain policy would ask your credentials every time when you open the EG. 

Community Manager
Posts: 2,697

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

@shenghuani - the proper way to handle scheduling and credentials is via a configured credentials.xml, which is described here in this SAS Note.  It's not a good idea to circumvent your IT/SAS Admin policy of always prompting for credentials.  If your site has determined that this policy is needed, you may be introducing an unwelcome risk into your work.  If you disagree with the policy, it's better to lobby with the admin and try to make your case.

Frequent Contributor
Posts: 138

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

Since originally posting my question, my company has moved our sas server and now uses our network credentials for access.  Because of this, I no longer have this issue.  However, I appreciate everyone trying to help me resolve it.  @ChrisHemedinger is right, it all boiled down to a corporate policy that doesn't allow the feature to hold the login information for next time EG is opened.

Occasional Contributor
Posts: 5

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

[ Edited ]

@elwayfan446 Good to know. My organization has also changed the server policy to let the user_id and password to be stored.

I just provided the answer for someone who had the same problem, if the server policy did not allow to store the credentials in the desktop.

Occasional Contributor
Posts: 5

Re: SAS EG Connection prompting for credentials every time I open an EG session or project

[ Edited ]

@ChrisHemedinger

I found it did not need the credentials.xml in EG7.1 to schedule a project. I tested and it worked without setting up this credentials.xml.

The only problem was the sever policy had overwriten the contents in the configurationV71.xml. If set to read only, then your user_id , password would always be there.

 From the link you provided, (http://support.sas.com/kb/30/917.html)

 

"If logon credentials for the SAS Metadata Server are not cached on the client side, scheduling of SAS Enterprise Guide projects is not possible."

 

To edit the configurationV71.xml by adding user_id, password and active profile name and set this file to read only will cache the logon credentials on the client side and allow the project to be scheduled. 

Ask a Question
Discussion stats
  • 11 replies
  • 800 views
  • 1 like
  • 4 in conversation