PI AF install in a mirrored SQL Server session

You can run PI Asset Framework (PI AF) in a mirrored SQL Server session. Although there are various ways to implement a mirrored SQL Server session, the instructions provided in this section use one example. In this example:

• The mirrored SQL Server session includes three machines: a principal server, a mirror server, and a witness server.

• Identical SQL Server editions are installed on the principal and mirror SQL Server machines using an instance name, while SQL Server Express edition is installed on the witness machine.

• The PI AF application service is installed on a machine that is separate from the machines used in the mirrored SQL Server session.

• The PI AF application service runs under a domain account.

• The PI AF client is installed on a separate machine, not on the machines that host the PI AF application service or PI AF SQL Server databases.

  Note: For more details, see the Microsoft article Database Mirroring (SQL Server).