Post reply

Database Mirroring and a NT AUTHORITY account for Database Engine

  • December 2, 2014 at 1:27 pm

    #312828

    Hi All

    I have just finished configuring my first test mirrored environment (High safety mode). I setup the database engine service accounts on each of the servers with domain\user.

    I inherited a production mirrored environment set up by someone else. On the production servers the database engine service account is NT Authority\user a local account. I am trying to practice

    installing Windows updates within a mirrored environment and I not sure how to proceed when the service account is NT Authority\user account. Any insight--should I change the service account to a domain\user? --and if so how would I approach this?

    Thanks

    Kathy

  • December 3, 2014 at 6:40 am

    #1762353

    plamannkathy (12/2/2014)

    Hi All

    I have just finished configuring my first test mirrored environment (High safety mode). I setup the database engine service accounts on each of the servers with domain\user.

    I inherited a production mirrored environment set up by someone else. On the production servers the database engine service account is NT Authority\user a local account. I am trying to practice

    installing Windows updates within a mirrored environment and I not sure how to proceed when the service account is NT Authority\user account. Any insight--should I change the service account to a domain\user? --and if so how would I approach this?

    Thanks

    Kathy

    Does the production system have mirror sessions running too?

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

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

  • December 3, 2014 at 7:06 am

    #1762368

    Yes the production servers have mirrored sessions also. The production servers were set up before the test servers. There was no testing. Now as the DBA, I would like to apply Windows Updates to the servers so I thought I should create a test mirrored environment to practice. I set up the test environment with the database engine having the domain/user and the production environment was setup with the database engine using the NT AUTHORITY\user account. Should I be concerned that my production mirrored environment uses this account or will doing a rolling update process work the same in both environments?

    Thanks

    Kathy

    **The Production servers are for Lync and Lync is actively managing that mirror opposed to standard mirror configuration--I just found this out from the consultant who installed this--

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

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