Endpoint SWAT: Protect the Endpoint Community

 View Only
  • 1.  SQL lost trust relationship with domain controller - SEP11RU7Mp2

    Posted Oct 04, 2013 06:33 AM

    Hi,

    We experienced some domain issues (DNS) on the network. The AD support suggest that we remove the SQL server from the domain and rejoin it to the domain. What impact will this have on a SEP 11RU7Mp2 database?

    We are currently experiencing liveupdate issues .....



  • 2.  RE: SQL lost trust relationship with domain controller - SEP11RU7Mp2

    Posted Oct 04, 2013 06:44 AM

    SEPM does not take care of where the SQL DB is located and if it is part of a domain or not as much as you give it the valid credentials to connect to it. If you use Windows authentication and it is related to domain accounts, of course they might not be valid anymore to access to a system out of that domain.



  • 3.  RE: SQL lost trust relationship with domain controller - SEP11RU7Mp2

    Broadcom Employee
    Posted Oct 04, 2013 06:47 AM

    you may need to re - run managment server configuration wizard.



  • 4.  RE: SQL lost trust relationship with domain controller - SEP11RU7Mp2

    Posted Oct 04, 2013 06:54 AM

    Just ensure the SEPM serives on both/all your SEPMs are stopped while the SQL server work is carried out, and they should just connect back in afterwards.

    In theory, you should only need to run the Management Server Configuration Wizard if the SEPMs are using Windows authentication for access to the DB, and that account somehow gets orphaned during the domain changes.  If you're using SQL Auth, you should be fine.

    Obviously take backups and whatnot.



  • 5.  RE: SQL lost trust relationship with domain controller - SEP11RU7Mp2

    Posted Oct 04, 2013 07:16 AM

    Great,will let you know how it turns out.



  • 6.  RE: SQL lost trust relationship with domain controller - SEP11RU7Mp2

    Posted Oct 04, 2013 08:07 AM

    Just go ahead and remove the SQL server from the domain and rejoin it to the domain --> there will be no impact.



  • 7.  RE: SQL lost trust relationship with domain controller - SEP11RU7Mp2
    Best Answer

    Broadcom Employee
    Posted Oct 04, 2013 10:04 AM

    Hi,

    Thank you for posting in Symantec community.

    Until and unless host-name and IP address is same there shouldn't be any concern to rejoin the same domain.

    As everyone suggested run management server configuration wizard after completing task.



  • 8.  RE: SQL lost trust relationship with domain controller - SEP11RU7Mp2

    Posted Oct 07, 2013 01:55 AM

    Still awaiting AD support to complete the task.