SQL 2012 install with configuration file fails with Managed Service Accounts

• polishpaul

  Old Hand

  Points: 397

  More actions

  February 15, 2013 at 2:50 pm

  #270235

  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"

• polishpaul

  Old Hand

  Points: 397

  More actions

  February 19, 2013 at 2:38 pm

  #1589379

  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>