SQLSCMControl() returned error 5040, 'The cluster node already exists.'
"SQLSCMControl() returned error 5040, 'The cluster node already exists.'" is an error in the Application event log with Event Id: 17052 and Source: MSSQL$InstanceName. The SQL Agent service will not start and shows in Cluster Administrator as Failed.This is accompanied by another error in the SQL Agent log file (sqlagent.out) as follows:
"SQLServer Error: 22022, CryptUnprotectData() returned error -2146892987, 'The requested operation cannot be completed. The computer must be trusted for delegation and the current user account must be configured to allow delegation.'"
You have probably just upgraded a clustered instance of SQL Server to build 3179 or later and are now panicking about how to fix it! Well the solution is very straightforward and explained in this article. The easiest solution is the second one in the article and involves ensuring the SQL Server service account is trusted for delegation.
Subsequent hotfixes and cumulative updates since build 3179 have not changed this behaviour, so we can assume that it is here to stay. I suggest you add it to your standard operating procedures for installing and upgrading clustered SQL Server instances in the future.
Not found what you're looking for?
Use this search box. It is tuned for SQL Server searches. Try it and see!Do you have a question about SQL Server? Would you like to answer a question?
Go to the SQL FAQ to get started.
