February 15, 2013 at 2:50 pm
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"
February 19, 2013 at 2:38 pm
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