DI Studio, SASApp access problem

[TurnTheBacon]

Hello,

When I start DI Studio, I log in with the administrator profile, and confirm that I have unrestricted access on SASApp:

Yet, when I use File -> New -> External File -> Delimited, and click "browse" in the wizard in order to locate the external file, I get this screen:

When I enter the exact same admin username and password that I used to log into DI Studio, I get an error message saying this:

The SAS troubleshooting page says this:

• Explanation: The specified server has been configured in metadata to allow SAS Token Authentication. These servers must have credentials specified for them in metadata in order for the object spawner to use to launch them.

• Resolution: Ensure that credentials are set for the server on the Options tab. After setting the credentials, restart your object spawner.

Any advice on how I can accomplish this? This is what my options look like (and "Test Connection" fails):

Thanks for your time.

[LinusH]

You said it yourself. Yes, you need host credentials to start a SASApp Workspace Server connection.

It's best practice not to have an unrestricted user connected to a host login. The unrestricted should mainly deal with metadata, not "real" data.

What kind of action do you intend to do?

[TurnTheBacon]

Thanks for the feedback. I'm running DI Studio in an image on a virtual machine now, if that matters. I need to read a CSV-file into a DI Studio job. but apparently can't browse for it in the external file wizard without having host credentials. I'll try to find information about how to do that, but would definitely appreciate recommendations (if you know about simple instructions someplace).

I thought that the DI Studio client sent in host credentials when I logged on as SAS admin. Still don't understand how I can be logged on with unrestricted access to SASApp, yet not have access to register an external file on SASApp. 😕

[LinusH]

Create a new meta user, and for that user, define a login wtih a userid which exists in your VM. This user should not be unrestricted.

[TurnTheBacon]

In Management Console there's a user with the name and userid "sasadm", with full access. He has the account "sasadm", defaultauth, and can read/write metadata.

In DI Studio there's a user profile with the name and userid "sasadm", and the correct machine/port settings. I log on as him using the exact same password as was set in Management Console.

Still, when logged in as sasadm I get the message "The user 'unknown' could not log on to the server "SASApp - Logical Workspace Server" when I test my connection to SASApp. Similarly I get the message "The user 'unknown' could not log on to the server "SASMeta - Logical Workspace Server" when I test my connection to SASMeta.

What am I missing here?

[LinusH]

Is sasadm defined as an internal account?

The you have to login to SAS metadata server as sasadm@saspw

Still, you need to have a login to the OS in your VM attached to that account (or provide one each time you open a WorkSpace server connection).

[DaveR_SAS]

sasadm is not a superuser account with access to everything. It is a special account used to administer metadata. You can't use it to connect to SAS DI Studio and access data, for example. As Linus said: "Create a new meta user, and for that user, define a login wtih a userid which exists in your VM. This user should not be unrestricted."

The steps for Adding a New User in SAS MC are here: SAS(R) 9.4 Management Console: Guide to Users and Permissions

For example, I used SAS MC to create a metadata identify for DI User 1. I specified my network credentials because I know that these credentials have access to the SAS App server and to the data I want to use.  Then I created a user proifile for DI User 1 and logged into DI Studio.

[Rakeon]

Hi,
I have the same problem....
I have DataIntegration in Windows OS, and I can't use DataIntegration in my LocalHost because I'm not able to access my SAS app Server....

I read the previous post...

but What does it means

" I know that these credentials have access to the SAS App server and to the data I want to use"?

How can I know the credential that allow to me to access my SAS app server?
 

[LinusH]

Local host means your local PC?
If you are trying to access a SASApp ws on a a Windows server talk to your SAS server admin.

[Rakeon]

yes,
my Local PC... 

[LinusH]

So what is the setup, did you manage to acquire a single user licence for learning purposes?
You need a full Data Integration Server install (with a configuration), DI Studio is not a stand alone product.

[Rakeon]

yes, 
of course, I have a user license, and I have already installed from setup SAS 9.4  the DI Server.

[Rakeon]

Hi,
finally I resolved my problem.
My mistakes was that I wrote all ID user in lower case instead of uppercase.