10-01-2013 07:05 AM
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:
Any advice on how I can accomplish this? This is what my options look like (and "Test Connection" fails):
Thanks for your time.
10-01-2013 07:15 AM
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?
10-01-2013 07:28 AM
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. :-/
10-01-2013 09:17 AM
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?
10-01-2013 09:55 AM
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).
10-01-2013 10:17 AM
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.
03-14-2017 05:44 AM - edited 03-14-2017 05:56 AM
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?
03-14-2017 02:12 PM