Skip to content

8 Comments

  1. Sunil Sane
    May 21, 2021 @ 9:27 am

    Hi Jay,
    While going through the LAB at some point, I lost my Domain Controller DC01 Hyper_V terminal and had to rebuild that from scratch. I got everything almost right where the CM-01 and PC-01 could connect to domain controller. But somehow CM_SQL user is not able to start the SQL service on CM-01. So I must be missing something on DC-01. I have added CM_SQL to Administrative group but still no avail.
    Also when I login to CM-01 as CM_SQL it does not get logged-in as administrator.

    Need your help

    Reply

    • Jay Singh
      May 21, 2021 @ 11:13 am

      Hi Sunil,

      This is a tough one, because if you remember you would have extended the AD schema on your previous domain controller. This was one of the prerequisites. Not sure if you have sorted that out. Also, losing a domain controller like this is not nice as there are tons of things that can go wrong. There is a trust relation of computer objects with AD as well among other things.

      Reply

      • Sunil V Sane
        May 22, 2021 @ 2:01 am

        Thank you Jay. It looks like may have to start from scratch and keep taking snapshots and backup somewhere else.

        Reply

        • Jay Singh
          May 22, 2021 @ 6:03 pm

          Keep one checkpoint for every vm and update whenever you make a major change.

          For my VMs, I backup with Windows Backup.

          Reply

      • Matthew Pierce
        April 30, 2022 @ 4:42 am

        Jay, this made me wonder this; If I already have a MECM 2111 environment in my work environment (Production) with several secondary site servers and two DP/MP/SMP servers, and I want to setup a brand new Primary Site Server in the same Domain, which I know is possible, do I need to go through the Extend AD Schema process again due to adding in this new Primary Site server? Thanks.

        Reply

  2. joeriz sagadraca
    July 25, 2021 @ 2:03 am

    By the way your blog helps me a lot.

    just wanted to know how to remove the registered serviceprincipal name because of typo error?

    MSSQLSvc/UNW-SC01.UNWIND.local:1433
        MSSQLSvc/UNW-sc0101.UNWIND.local:1433

    Reply

  3. Azeem
    March 31, 2022 @ 4:13 pm

    Hello Jay,
    I’m lost at part 7 video at 32:55. I’m seeing the sql database as read-only. I tried to change the permission of the database folder in database hard drive from read-only to (Unchecked) using local admin account. I tried attaching the database again and I’m getting “failed to retrieve data for this request”. Appreciate your help.

    Reply

  4. Osama Yaqub
    June 25, 2022 @ 9:48 pm

    Hi Jay,

    These instructions so far have been brilliant. I just wanted to know if there was a way to do them manually as I can’t get my head around the way the files have been stored. Forgive my ignorance, I’m using a Mac and it’s quite difficult for me to work equivalent methods.

    Would love to hear back and I appreciate your time and efforts on this ❤️.

    Osama

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *