Skip Navigation

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 kb to read article KB34373.
  • 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.