- I tried to add a new node to SQL Server (2012 Standard) Failover, that is already installed on another node in Windows2012 Failover Cluster
- I have an issue with non editable field wiht input for SQL Server Agents Account Name
- there could be the same AD name as for SQL Server Database Engine (e.i.)
- my account access haven't AD admin privileges
- access, account and setting for SQL Server Agent on parent node are accesible and settable
SQL Server Failover Cluster – Problem Adding a New Node to a SQL Server 2012 Failover Cluster
clusteringfailoversql serversql-server-2012
Best Answer
As per your comments in your question, what you need to do is two-fold:
For the first step, one way to do this is through PowerShell (utilizing the FailoverClusters module):
Execute each of those blocks of code separately instead of just all at once. You'll be able to confirm whether or not that cluster resource type exists before just blindly attempting to add it.
Then for the second step, here's what you need to do to add the SQL Server Agent as a resource in your failover cluster resource group:
You may need to go into the registry at the following location and ensure those keys (one will contain the string "AGENT", another "SQL_ENGINE") are set to 1 (this is where it is recorded on what was installed correctly. 1 denotes correct installation):
That should get you to a place where you can now install an additional node and have the SQL Server Agent service account appear. Of course, prior to starting ensure that you have a back out here (especially with the registry editing).