Prerequisites: Configuring database mirroring

Configure the principal server and mirror server to permit access from remote computers.

Configure the principal server and mirror server to have the same permissions.

Set up a witness server that you will use to monitor the principal server.

Configure the 

Microsoft SQL Server

 Agent to use a domain user account with the same local administrative permissions as the 

Windows

 account that runs the 

BlackBerry UEM

 services.

Verify that the domain user account has permissions for both the principal server and mirror server.

Verify that the DNS server is running.

On each computer that hosts a 

BlackBerry UEM

 database instance, in the 

SQL Server

 2012 Native Client, turn off the Named Pipes option. If you choose to not turn off the Named Pipes option, visit https://support.blackberry.com/community to read article 34373.

To review additional prerequisites for your organization’s version of 

Microsoft SQL Server

, visit technet.microsoft.com/sqlserver to read Database Mirroring - SQL Server 2012 or Database Mirroring - SQL Server 2014.

If the mirror database uses the default instance, the 

BlackBerry UEM

 components can connect to the mirror database using the default port 1433 only, not a custom static port. This is due to a limitation of 

Microsoft SQL Server

 2005 and later. For more information about this issue, see SQL 2005 JDBC Driver and Database Mirroring.