SQL 2012 install with configuration file fails with Managed Service Accounts

  • Hello, I'm having trouble with installing SQL using Managed Service Accounts while using a configuration file for the installation.

    The following error occurred:

    Managed Service Account 'MyDomain\userSQLAgent' provided for 'SQLSERVERAGENT' is either not valid, not linked to this machine or cannot be used for this setup scenario.

    This is a Windows 2008 R2 Enterprise server running on VMWare on a domain. Using SQL Server 2012 Enterprise.

    I created the service accounts on AD using Powershell and confirmed that they exist in the OU. I also linked these MSA's with their respective servers and verified this as well. I made sure to install KB 2494158 per MS documentation. I verified that i can assign these accounts to services on the server.

    I ran the PowerShell commands from my workstation. Is it necessary to run the Add-ADComputerServiceAccount on the actual server? It doesn't seem to be necessary as when I query the account it shows the server its assigned to. Any ideas? I could not find any answers on the forums.

    This is the line in the config file for one of the accounts:

    AGTSVCACCOUNT="MyDomain\UserSQLAgent"

  • I missed a step in the setup. I was under the impression that associating the account with the computer was the same as "installing" it.

    I just needed to install the accounts like this:

    Install-ADServiceAccount <accountname>

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

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