This article helps you resolve issues that occur because of a corrupted Windows user profile.
Symptoms
You receive the following error message:
The User Profile Service service failed the sign-in. User profile cannot be loaded.
Cause
If you log in as the affected user, you'll get a temporary profile. This is a good indication that the user profile is corrupted or that you're a guest user.
Resolution
If you're a guest user, then you must be added to the appropriate groups. For more information, see Add or delete users.
If you aren't a guest user, follow the steps in Fix a corrupted user profile in Windows to either repair the profile or delete and re-create the profile.
More information
Consistent authentication issues in SQL Server
Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.
