• one more question?

    As per BOL http://msdn.microsoft.com/en-us/library/ms189434(v=SQL.105).aspx

    when using windows authentication, SQL Engine account should be domain account for configure database mirroring.

    as per my current instance can login mixed mode authentication such as users 'sa', 'administrator'

    Can we use like this as below

    Principal

    Specify the service account of the principal server instance.

    Principal servername\Administrator

    Mirror

    Specify the service account of the mirror server instance.

    Mirror servername\Administrator

    But SQL server service account running local user account for example

    1. Principal servername\SQLServEngine - for MSSQL

    2. Principal servername\SQLServAgent - for Agent

    Both user added into login at sqlserver instance.

    thanks