Some user use Saspy cannot connect SAS

[jaklng2019]

We use saspy in Linux python to connect SAS in Windows Server by using iomlinux. The administrator in Windows Server can establish the connection successfully but other normal user fail to build up the connection and throws the following error in Python: We failed in getConnection The application could not log on to the server "xxxxxxxxxx". The user ID "xxxxxx" or the password is incorrect. SAS process has terminated unexpectedly. Pid State= (35687, 64000) SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.

[AnandVyas]

Hi @jaklng2019,

I think checking the offical link could help you start with this https://sassoftware.github.io/saspy/troubleshooting.html#iom-specific-errors

[jaklng2019]

I think those account don't have permission to connect. How can i grant the specific permission on Windows Server rather than grant the administrator role?

[sastpw]

Connecting to a workspace server requires credentials which are stored in the metadata server (OMR). The error you are getting is pretty clear that the credential being provided are not valid to be able to connect to that server. I would need to have more information to have a better idea of anything more than that. I assume you expect the credentials to work.It may be more productive to open an issue on saspy to get direct help with this: https://github.com/sassoftware/saspy/issues  (click New Issue).

Thanks,

Tom

[Tom]

Is it a permission issue on the SAS server?  Can those users connect to that SAS server using some other tool? Like Enterprise Guide or SAS/Studio?

Or is it different environments on Linux?  Perhaps you can test by having the admin user try to connect to SAS using when running as one of the other users on the Linus machine that is running the python?

[jaklng2019]

I think it is a permission issue on SAS server. If i add the user into the administrator group on SAS server (Windows Server), then the user can establish the connect through saspy which hosts in another Linux server.

Are there any permissions that i need to grant for the user to connect or any ports? it is not acceptable to grant the administrator role for all user. However, those users can connect to SAS through Enterprise Guide and SAS/Studio.

[jaklng2019 · Accepted solution]

Finally i find a workaround. I updated the local group policy from SAS server. I added the user into this policy "Local Computer Policy >> Computer Configuration >> Windows Settings >> Security Settings >> User Rights Assignment >> Local Policies >> Log on as a batch job", then user can establish the connection through saspy.

[AnandVyas]

Oh, good one! however that's a pre-requisite for using SAS on windows machines. Glad you fixed it.