06-12-2013 02:43 PM
Is it possible running a Stored Process on the SAS Portal
using Windows Authentication?
I have a streaming stored process with a couple of pass-thru
queries. Problem is the DB now wants us to use Windows Authentication versus
the SQL Authentication we were using before.
06-14-2013 12:43 AM
I'm not familiar with SAS Portal but a SAS stored process runs on a SAS Stored Process Server, and that server can be configured to run with different Multiuser Credentials.
On our SAS Server this is set to use a SAS service account - sas_srv. This may be different in your configuration so you will need to check in SAS Management Console to confirm this. For Windows authentification to work the user account(s) defined for the Multiuser Credentials must be defined in SQL Database as Windows Authenticated users.