Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2012 install with configuration file fails with Managed Service Accounts Expand / Collapse
Author
Message
Posted Friday, February 15, 2013 2:50 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 2:20 PM
Points: 5, Visits: 63
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"
Post #1420784
Posted Tuesday, February 19, 2013 2:38 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 2:20 PM
Points: 5, Visits: 63
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>
Post #1421858
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse