Windows user profile can't be loaded in SQL Server
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.