Getting error message for SQL servers "Cannot generate SSPI context"

Products

• Control Compliance Suite Standards Server
• Control Compliance Suite
• Control Compliance Suite Standards Module

Issue/Introduction

In Data collection, we are getting this error message "Cannot generate SSPI context".

 

Cause

There are a number of different things that can cause this error.

Resolution

Review the number of different things that can cause this to happen from the following article.

https://stackoverflow.com/questions/1812541/cannot-create-sspi-context

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.

https://docs.microsoft.com/en-us/archive/blogs/farukcelik/basics-first-udl-test