question

AMRITANSHUAMRITANSHU-5038 avatar image
0 Votes"
AMRITANSHUAMRITANSHU-5038 asked MiaMiao-MSFT answered

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

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


18589-img-20200818-185853.jpg


sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AMRITANSHUAMRITANSHU-5038,

Is the reply helpful?

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

0 Votes 0 ·
MiaMiao-MSFT avatar image
1 Vote"
MiaMiao-MSFT answered MiaMiao-MSFT edited

Hi @AMRITANSHUAMRITANSHU-5038

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://docs.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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MiaMiao-MSFT avatar image
0 Votes"
MiaMiao-MSFT answered

Hi @AMRITANSHUAMRITANSHU-5038,

Is the reply helpful?

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MiaMiao-MSFT avatar image
0 Votes"
MiaMiao-MSFT answered

Hi @AMRITANSHUAMRITANSHU-5038,

Is the reply helpful?

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.