Recently had a user with this error. I’ve had this before after a domain migration I had Manually create SPN , but this SQL server hadn’t moved.

In the end it was the User account that was locked in AD!