The main differences between using a SAS Workspace Server versus a SAS Stored Process Server for executing stored processes in a BI environment are as follows:

• The SAS Workspace Server is launched using the end user's credentials.
  
  The SAS Stored Process Server is launched using the multi-user credentials account defined in the properties of the server (by default, the SAS General Servers group login account, sassrv, is used).


• The SAS Workspace Server produces "Package" results or no results. Starting in SAS^® 9.3, the workspace server can also produce "Stream" results except for stored processes that use sessions or replay (such as embedded images in streaming output).
  
  The SAS Stored Process Server can produce Package, Stream, or no results. See the SAS Stored Processes: Result Types web page for more information.


• There are differences in pooling versus load-balancing configurations that are supported by each server. For further information, see the SAS^® 9.4 Intelligence Platform: Application Server Administration Guide documentation on Understanding Server Load Balancing and Understanding Server Pooling.

In summary, there are two choices for executing a stored process:

• Register your stored processes to execute on a SAS Workspace Server. Stored processes running on a SAS Workspace Server execute using the client application logon credentials for the end user. Your stored processes can be registered to produce no results, package results, and in SAS 9.3 and later, streaming results except for stored processes that use sessions or replay (such as embedded images in streaming output).


• Register your stored processes to execute on a SAS Stored Process Server. The stored processes execute using the multi-user credentials defined in the server properties. By default, SAS uses the sassrv user ID, which is the login account for the SAS General Servers Group. Your stored processes can be registered to produce no results, streaming, or package results, and the stored processes can use multi-value input parameters.

You select the server of choice by editing the properties of the stored process. In SAS^® Management Console, right-click the stored process, select Properties, and click the Execution tab. The Server type selection is near the top of that screen.   

Operating System and Release Information