- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi folks,
Our users have SAS PC File Server installed on their computers. The SAS PC File Server is started automatically as a service. Our SAS Server is Linux on 9.4M5.
We don't have any problem importing or exporting to local drive, the user and password information in this case is not required.
But if the user tried to import or export over the network the following error appears:
proc import file="\\network\directory\File.xlsx"
out=class
DBMS=EXCELCS REPLACE;
PORT=9621 ;
SERVER="my-computer-name";
run;
ERROR: Unable to open file \\network\directory\File.xlsx. It does not exist or it is already opened exclusively by another user, or you need permission to view its data.
If we add user and password information, even if we add domain on user name, the following error appears:
proc import file="\\network\directory\File.xlsx"
out=class
DBMS=EXCELCS REPLACE;
PORT=9621 ;
SERVER="my-computer-name";
SERVERUID="my.user";
serverpass="{sas002}FF5BB7293C5BE73F1BF62E514719C47C138D163D42D54M38";
run;
ERROR: Server is unable to authenticate user credentials. (missing or invalid SERVERUSER='<domain\username>'; SERVERPASS='<password>'; enclosed in quotes).
Any idea?
Regards,
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks folks! We reconfigure the SAS PC File Server and now it's working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Can the users save a file to that path using Excel? Also, does the account under which is the PC File Server service is running have the needed permissions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks folks! We reconfigure the SAS PC File Server and now it's working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Can you explain what part of the configuration needed to be changed to fix the issue? It might help others in the future that have similar issues.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content