Defining Multiple Application Servers
Scenario 2: Using Multiple Application Servers with SAS Web Report Studio
Suppose that you want to create an environment in which row-level security can be strictly enforced for a set of SAS Web Report Studio users. (For a detailed description of this feature, see Chapter 1, “Overview of BI Row-Level Permissions,” in SAS Guide to BI Row-Level Permissions.)
Part of the setup is to create a special workspace server for use by the report creators who need the secure environment. This special workspace server is a component of a new SAS Application Server. See the following figure.
Defining Multiple Application Servers 83
Figure 10.3 Using a Second Application Server to Enable Row-Level Security
The original workspace server can service users of other applications and users of SAS Web Report Studio whose access to data does not need to be so closely controlled.
Create a SAS Application Server for a SAS Solution
SAS solutions such as SAS Demand-Driven Forecasting require unique SAS Application Servers in order to properly function.
If you are deploying your SAS solution on a system without any pre-existing SAS software, you can proceed normally making sure to name the SAS Application Server Context for your solution. For more information, see the SAS Intelligence Platform:
Installation and Configuration Guide and any installation documentation for your particular solution.
If your system already has SAS software and you are adding a SAS solution, this topic steps you through using the SAS Deployment Wizard to create a SAS Application Server for a SAS solution. (SAS Demand-Driven Forecasting is the solution used to illustrate this procedure. However, the process is similar for most SAS solutions.) To create a SAS Application Server for a SAS Solution, follow these steps:
1. Stop all running SAS servers and applications.
For more information, see Chapter 5, “Operating Your Servers,” in SAS Intelligence Platform: System Administration Guide.
2. Start the SAS Deployment Wizard from the highest-level directory in your SAS Software Depot using the command appropriate for your operating system:
Table 10.1 Start-up Commands for the SAS Deployment Wizard
Operating
System Command
Windows setup.exe -record -deploy
Operating
System Command
UNIX setup.sh -record -deploy
z/OS First invocation of the deployment wizard to install the metadata server as a 64-bit application:
setup.rexx -z64 -record -deploy
Second invocation of the deployment wizard to install the remainder of your SAS 9.3 order as a 31-bit application:
setup.rexx -record -deploy
To use a temporary directory other than /tmp, specify -templocation new-temp-dir.
Note: Using the -record -deploy options causes the wizard to create a response file that records the inputs that you supplied. This can be helpful when you want to repeat the deployment on other machines or when troubleshooting a
deployment issue.
By default, the deployment wizard writes the response file in the following location:
• Windows:
C:\Documents and Settings\current-user
\sdwresponse.properties
• UNIX and z/OS:
~/sdwresponse.properties
3. Choose Perform a Planned Deployment, and Install SAS Software only.
4. Next, select the deployment plan provided with the image.
Defining Multiple Application Servers 85
5. Select the machine.
In this example, the server machine is used. Continue through the wizard. When you reach the Deployment Summary, click Start to begin the installation process. When the SAS Deployment Wizard finishes, your SAS solution and its dependent
components are installed on the selected Server machine, and are ready to be configured. Restart all SAS servers and spawners, and then invoke the SAS Deployment Wizard a second time.
6. Select Perform a Planned Deployment, and specify Configure SAS Software only.
7. Next, specify the deployment plan provided with the image.
Select the machine. (In this example, the server machine is used.)
8. When prompted, specify the same configuration directory and level that is currently in use.
The deployment wizard recognizes that this configuration directory and level directory already contains files.
9. Click Yes to proceed.
Defining Multiple Application Servers 87
A page listing the products to configure opens.
By default, the SAS Deployment Wizard presents only products that have not been configured. Any products required by your solution but not yet configured are automatically selected. However, since the deployment wizard is creating a new SAS Application Server, the SAS servers required and used by your solution remain to be configured.
In this example, the deployment wizard automatically specifies a SAS Pooled Workspace Server, a SAS Workspace Server, and a SAS Stored Process Server, to provide the required “exclusive” access to a SAS Application Server for your solution.
10. Select Next to proceed.
You must specify the same values that you used during the initial deployment here.
List the host information for the SAS Metadata Server and valid credentials for the SAS Administrator, the SAS Trusted User, and SAS Spawned Servers account.
Continue through the wizard pages, specifying the same connection information until the Create SAS Application Server Context page appears.
11. Select Create a SAS Application Server Context.
A page prompts you for the name of the SAS Application Server. A unique name is required, and SAS suggests that a name easily associated with your solution be used.
In this example, SASDDCF is specified.
12. Enter the name of your SAS Application Server context, and click Next.
For each server that you add to the SAS Application Server, you are prompted for the context to use. The same name that is used in the server context page should be used with each server.
13. Enter your SAS Application Server context and click Next.
Defining Multiple Application Servers 89
The deployment wizard prompts you for a main port for each server that you add.
The SAS Workspace Server and SAS Pooled Workspace Server being added to your server context can use whatever port you want, including the same port the previous configuration might have used for them (provided that no other conflicts exist). The SAS 9.3 object spawner manages these workspace servers to avoid port conflicts when it spawns them. However, the SAS Stored Process Server requires unique port values for its multi-bridge connections.
This example uses a variation on the default values of 8611, 8621, and 8631 combined with calculated defaults for ports not reserved. Any ports that are appropriate and available can be used. They merely must be unique and not in use.
14. Enter multi-bridge ports for the stored process server and click Next.
Continue through the wizard, providing input for the various configuration options as required by the solution being configured.
15. Specify the dependency for your solution server configuration, using the newly created SAS Application Server.
(In this example, the SAS Application Server is named SASDDCF.)
Continue through the wizard, providing configuration input.
16. When the Deployment Summary appears, click Start to begin the configuration process.
When the SAS Deployment Wizard finishes, your SAS solutions are installed and configured on the selected server machine and are ready to use. The wizard displays Configuration Guidelines and Details at the end of your deployment process.
17. Restart the SAS Object Spawner to detect the new servers that you have just deployed.
For more information, see “Using Scripts to Operate SAS Servers Individually” in Chapter 5 of SAS Intelligence Platform: System Administration Guide.