Architecting, installing and maintaining your SAS environment

Is it possible running a Stored Process on the SAS Portal

Reply
Frequent Contributor
Posts: 115

Is it possible running a Stored Process on the SAS Portal

  Hello all,

    

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.

Super User
Posts: 3,102

Re: Is it possible running a Stored Process on the SAS Portal

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. 

Ask a Question
Discussion stats
  • 1 reply
  • 352 views
  • 0 likes
  • 2 in conversation