In Data collection, we are getting this error message "Cannot generate SSPI context".
There are a number of different things that can cause this error.
Review the number of different things that can cause this to happen from the following article.
Then using a UDL test, verify that each CCS Manager is able to connect to the remote SQL Server.
For details on using UDL, please see the following Microsoft article.