Establish a Service Account for the Application (if Applicable)

If the database is on SQL Server, we recommend establishing a service account (e.g., “RSUser”) that SEP will use to connect to the ReliaSoft database as well as any other external databases that may be used to create “custom connection” dashboards in the Reliability Data Warehouse (RDW). This account must meet several requirements:

• It must be an Active Directory account.
• Ideally, it should have a password that does not expire (recommended).
• If the database is on SQL Server, a user should be assigned to a public server role, with at least the db_datareader and db_datawriter roles for the ReliaSoft database. (If the database does not yet exist, you will need to add the roles via SQL Server after you create it. See Create the ReliaSoft Database.)
• It should have at least the db_datareader role for any other SQL Server databases that will be used by RDW custom connections

If you plan to use this account as a database connection for Open buttons, it must also meet the requirements for an “impersonation user” for all computers that will run desktop applications — specifically, it must be on a trusted domain and it cannot be a local admin, domain admin or member of any Windows admin group (see Configure Remote ReliaSoft).

Alternatively, you can establish a separate impersonation account for the application admin to use for Open buttons only. For details on other options to configure the database connection for Open buttons, see SEP Admin Page in the SEP help.