topic Re: Some user use Saspy cannot connect SAS in New SAS User

Some user use Saspy cannot connect SAS

jaklng2019 — Wed, 04 Dec 2019 09:59:01 GMT

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.

Re: Some user use Saspy cannot connect SAS

AnandVyas — Wed, 04 Dec 2019 11:41:04 GMT

Hi @jaklng2019,

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

Re: Some user use Saspy cannot connect SAS

sastpw — Wed, 04 Dec 2019 15:13:58 GMT

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

Re: Some user use Saspy cannot connect SAS

Tom — Wed, 04 Dec 2019 15:30:28 GMT

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?

Re: Some user use Saspy cannot connect SAS

jaklng2019 — Thu, 05 Dec 2019 06:11:51 GMT

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.

Re: Some user use Saspy cannot connect SAS

jaklng2019 — Thu, 05 Dec 2019 06:20:18 GMT

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?

Re: Some user use Saspy cannot connect SAS

jaklng2019 — Thu, 05 Dec 2019 09:06:41 GMT

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.

Re: Some user use Saspy cannot connect SAS

AnandVyas — Thu, 05 Dec 2019 09:40:21 GMT

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