Create an Application Pool Identity

The application admin(s) may determine that SEP needs to display RDW dashboards based on custom connections to external Access databases (or to external SQL Server databases if the ReliaSoft database is on Oracle). If so, you may wish to set a service account (e.g., “SynUser”) as the IIS application pool identity (see Establish a Service Account for the Application). This is not recommended if your website is public.

1. In the Connections pane of the IIS Manager, click Application Pools.
2. Right-click the website’s application pool and choose Advanced Settings on the shortcut menu.
3. For the Identity property, click the ... button to open the Application Pool Identity window. Select the Custom account option and click Set to open the Set Credentials window. Enter the account credentials (domain\username) for the service account and click OK.

Note: For Access databases with the *.accdb file type, the RDW dashboard can only be displayed if the database was created with the same version of Microsoft Office (32-bit or 64-bit) that is installed on the web server (for SEP) or on the individual user's computer (for ReliaSoft desktop applications).

To ensure that the RDW dashboard will display regardless of which version of Microsoft Office is installed, use the *.mdb file type instead.