SAS PC File Formats | Error importing or exporting from network

[MariaD]

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, 

[CurtisMackWSIPP]

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?

[MariaD · Accepted solution]

Thanks folks! We reconfigure the SAS PC File Server and now it's working.

[Tom]

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.

[MariaD]

Hi, @Tom 

In fact, our service desk uninstall and install it again.

Regards,