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.

More information

Consistent authentication issues in SQL Server