BookmarkSubscribeRSS Feed
Jaime
Fluorite | Level 6

  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.

1 REPLY 1
SASKiwi
PROC Star

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. 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 953 views
  • 0 likes
  • 2 in conversation