Adding second node to SQL Server cluster fails. - Credential for SQL Server Agent is invalid.
Question
Thursday, February 17, 2011 9:49 AM
Dear all,
I have created a cluster with the following details:
OS : Windows Server 2008 R2, Hyper-V
I have already installed SQL Server 2008 R2 on NODE1.
When I am adding a NODE from NODE2 i am getting the following error when it comes to service account:
The following error occurred:
The credentials you provided for the SQL Server Agent service are invalid. To
continue, provide a valid account and password for the SQL Server Agent service
Error result: -2068578304
Result facility code: 1204
Result error code: 0
Any idea / help is appreciated.
Many thanks
Vinay
V
All replies (5)
Tuesday, February 22, 2011 9:48 AM âś…Answered
Hi,
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.
Please let me know if you have any questions. Hope this helps.
Best Regards,
Chunsong Feng
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Tuesday, February 22, 2011 10:16 AM
Have you checked "Use the same account for all Services" , If not make sure that we specifically give the account and password for all the accounts.
Regards
Ashwin Menon
Wednesday, February 23, 2011 11:48 AM
Using the account already configured on the other node for cluster group for SQL Agent, ensure you are using the right password. Simple way to test this is to attempt to login using that account name and password.
Regards,
Mark Broadbent.
Contact me through (twitter |blog )
Please click "Propose As Answer " if a post solves your problem
or "Vote As Helpful " if a post has been useful to you
Wednesday, February 23, 2011 1:52 PM
Does service account have enough permissions on node2. Are you using right password?
Monday, March 31, 2014 4:49 AM
Hi Vinay,
This responce is for others to refer; this issue is common with SQL cluster setup where adding node in the cluster doesnt allow GUI to specify SQL agent user name and you cant proceed with the Setup.
Solution is to use CLI :
setup.exe /q /ACTION=AddNode /IAcceptSQLServerLicenseTerms=true /INSTANCENAME="MSSQLSERVER" /SQLSVCACCOUNT="SVCAccount Name" /SQLSVCPASSWORD="PASSWORD" /ASSVCACCOUNT="SVCAccount Name" /ASSVCPASSWORD="PASSWORD" /AGTSVCACCOUNT="SVCAccount Name" /AGTSVCPASSWORD="PASSWORD"
Cheers!!