Create a mirrored SQL Server session

Follow these steps to create a mirrored SQL Server session on the principal server:

1. On the principal server computer, right-click the PI AF SQL Server database (typically named PIFD) and select Task > Mirror.

   The Database Properties – PIFD window opens with the Mirroring page selected.

2. Click Configure Security.

   The Configure Database Mirroring Security Wizard opens.

   1. On the Include Witness Server page, select Yes.

   2. Click Next.

   3. On the Choose Servers to Configure page, select Witness server instance.

   4. Click Next.

   5. On the Principal Server Instance page, click Next.

   The Mirror Server Instance page opens.

   1. Select the mirror server from the Mirror Server Instance list.

   The Connect to Server window opens with the selected server/instance.

   1. Click Connect to verify that you are able to connect to the mirror server.

      If you are unable to connect, verify that the Listener port is available to the principal SQL Server.

   2. Click Next in the Mirror Server Instance page.

3. Select the witness server on the Witness Server Instance page.

   The Connect to Server window opens with the selected server/instance.

   1. Click Connect to verify that you are able to connect to the witness server.

      If you are unable to connect, verify that the listener port is available to the principal SQL Server.

   2. Click Next in the Witness Server Instance page.

   The Service Accounts page opens.

   1. Enter the account name under which each SQL Server Database Engine runs in the Principal, Witness, and Mirror fields.

   The accounts must be domain accounts, which includes virtual accounts like NT Service\MSSQLSERVER. The accounts must be either in the same domain, or in different trusted domains. For virtual accounts, use the following format for the account name: DomainName\ComputerName$.

   1. Click Next.

   2. Review the choices on the Complete Wizard page. If changes are required, click Back to go back and make the changes, and then click Next to return to the Complete Wizard page.

4. Click Finish.

   The Configuring Endpoints window opens. When the endpoint configuration is complete, the Status column displays Success.

5. Click Close.

6. Click Start Mirroring in the Database Properties window.

   The Database Properties – PIFD window opens. The Operating mode is set to High safety with automatic failover (synchronous).

7. Click OK.

If there are no errors, the mirrored SQL Server system configuration is complete and the system is ready to use. The PIFD database is shown in the Principal, Synchronized mode. If there are errors, check the Mirroring page in the PIFD properties for invalid entries and make any required corrections.