Configuring the Windows Environment

Overview

This section outlines the necessary configuration procedures and server tasks that you must complete following installation of SAS Federation Server in a Windows environment.

Federation Server Directory Permissions

The recommended directory permissions for SAS Federation Server installed on a Windows® platform are listed in the following table:
Directories
Users
Default Permissions
SASHome
SASHome\fedserver\server instance
Installer, Administrator
Full Control
Process user
Read and Execute, List Folder Contents
SASHome\fedserver\server instance\var
Installer, Administrator
Full Control
Process user
Read, Write, List Folder Contents
The user who backs up SAS Federation Server; Backup Administrator
Read, List Folder Contents
TranPath as specified in the server configuration file
Installer, Administrator
Full Control
Process user
Read, Write, List Folder Contents
The user who backs up SAS Federation Server; Backup Administrator
Read, List Folder Contents
Note: All other users have no access.

Configuring ODBC Connections

This section describes how to configure ODBC connections for SAS Federation Server in a Windows environment.
To access a database through ODBC with SAS Federation Server, a driver for ODBC for the specific database must be used. SAS Federation Server comes with the ODBC drivers for several databases. The database and database connection must also be configured as an ODBC data source.
To access a database through a vendor supplied client, the client must be installed and configured according to the vendor documentation.
To add an ODBC data source, use the ODBC Data Source Administrator in Microsoft Windows. To set up a new ODBC connection:
  1. Click Startthen selectControl Panel.
  2. Double-click Administrative Toolsthen selectData Sources (ODBC).
    Note: In Windows 7, the view of the Control Panel can vary. If you do not see Administrative Tools when you open the Control Panel, click System and Security to access Administrative Tools, Data Sources (ODBC).
  3. Click Add.
  4. In the ODBC Data Source Administrator window, select the driver that is appropriate for your data source.
  5. In the ODBC Driver Setup dialog box, enter the Data Source Name, Description, and database-specific configuration options. These values are required, and can be obtained from your database administrator.
Use the vendor supplied client configuration utility for connections that are not ODBC.

Starting and Stopping the Windows Service

The SAS® Federation Server runs as a Windows service that is accessible through the Control Panel or Management Console. To access the service:
  1. Click Startthen selectSettingsthen selectControl Panel
  2. Double-click Administrative Toolsthen selectComputer Management.
  3. Expand the Services and Applications folder.
  4. Click Services.
  5. ClickSAS Federation Server.
  6. Click either Stop the service or Restart the service.
Note: Version number differences between the database schema and the Federation Server itself can terminate the start process. Major version numbers must match. The minor version number of the schema can be 1 less than the minor version number of the server.
Modifying the Service Log On
At installation, SAS Federation Server service is configured to start using the local system account. Because this account can have some restrictions, such as accessing network drives, it is suggested that you modify the service log on account to an account that has the appropriate privileges to run SAS Federation Server.
To modify the SAS Federation Server service log on:
  1. Select Control Panelthen selectAdministrative Tools.
  2. Double-click Services, and select the SAS Federation Server service.
  3. Click the Log On tab, select This account, and enter Account and Password credentials for a user with administrative privileges.