• what command did you use to backup and restore the cert?

    smtzac (10/23/2014)


    Where do I put service account name and how?

    CREATE ENDPOINT <endpoint_mirroring>

    STATE = STARTED

    AS TCP ( LISTENER_PORT = 7023 )

    FOR DATABASE_MIRRORING (ROLE=PARTNER)

    You don't!!

    The link you posted above has some good info but is missing critical TSQL steps.

    Once you create the endpoint using the script you posted above, you then create a login for the svc account of the partner instance(s). Once the login is created you grant the login(s) CONNECT on the Endpoint. Do you understand this?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉