Database mirroring with no Built in Admin account?

  • Hi All,

    I have setup mirroring with all services running under the same domain account which also has SA rights.

    Everything is working as expected.

    However when re-moving the BUILTIN\Administrators account.

    and start up mirroring again it fails with ....network address can not be found or does not exist

    I have added the the BUILTIN\Administrators account back with SA rights and mirroring works. I then removed SA from the account and it fails again.

    Is they an issue with removing this account when mirroring?

  • Additional information:

    This is setup on 2 64bit 2003 Virtual machines

    Using 64bit Standard edition.

    No Witness

    All instances are running under the same domain account

  • What is the statup SQL Server service account?

    1. I started the sql server service in all the 3 server with domain account which has been added to the win admin group.

    2. I did the same test at my end it works with no issues.

    3. DB mirroring is setup using the same domain account

    Cheers,

    Got an idea..share it !!

    DBA_Vishal

  • Sorted,

    Would help if the accounts was apart of SA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply