Can't be able to add node to a SQL server failover cluster

Question

While adding a node to a Sql server failover cluster,
I am getting error like this -
Error: The credentials you provided for the Sql server agent service are invalid.

Answer 1

Hi @AMRITANSHU AMRITANSHU

Error: The credentials you provided for the Sql server agent service are invalid.

Quote from the similar case : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/43e025f0-538c-4416-8950-468443759329/adding-second-node-to-sql-server-cluster-fails-credential-for-sql-server-agent-is-invalid?forum=sqldisasterrecovery

The error clearly states that the service account for SQL Server Agent service is not invalid. Please make sure you have input correct account name and password and also ensure that the Activity Directory Service (ADS) is running properly so that the account you use can be validated by ADS.

Similar case: https://social.msdn.microsoft.com/Forums/en-US/5c2f43e9-f44f-4d1d-b3cf-86fc1dd6e765/sql-server-agent-service-are-invalid?forum=sqldisasterrecovery

More information: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup?view=sql-server-ver15#to-add-a-node-to-an-existing--failover-cluster-instance

BR,
Mia
If the reply helped, please “Accept Answer” and upvote it.--Mia

Answer 2

Hi @AMRITANSHU AMRITANSHU ,

Is the reply helpful?

BR,
Mia
If the reply is helped, please do "Accept Answer".--Mia

Answer 3

Hi @AMRITANSHU AMRITANSHU ,

Is the reply helpful?

BR,
Mia
If the reply is helped, please do "Accept Answer".--Mia