Need to understand Impact of Domain rejoin on MSA account for MSSQL Server

Sushant Yadav 20 Reputation points
2023-05-30T09:44:38.4766667+00:00

For servers running MSSQL Server 2017, we want to do an in-place OS upgrade. Additionally, we used an MSA account to log in to services.Server will be removed from the domain during the OS upgrading process and rejoined after the upgrade. So it's important to know if anything affects the MSA account. In the past, we had trouble with MSSQL logon accounts since the login ID and password were mismatched.

Is it possible to push or resync a password using AD for MSA account?

What are the potential difficulties that might arise?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,606 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,053 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
5,805 questions
0 comments
Accepted answer
  1. CosmogHong-MSFT 22,541 Reputation points Microsoft Vendor
    2023-06-02T09:07:19.1+00:00

    Hi @Sushant Yadav

    You can use the Active Directory module for Windows PowerShell to manage service accounts in Active Directory Domain Services (AD DS).

    Please refer to this doc: Managed Service Accounts.

    Best regards,

    Cosmog Hong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest