Applies to: SQL Server (all supported versions)
|Product Name||SQL Server|
|Message Text||Windows NT user or group '%s' not found. Check the name again.|
This error occurs when SQL Server is unable to create a login based on Windows principal (such as a domain user or a Windows domain group). An error message like the following is reported to the user
Error 15401: Windows NT user or group '%s' not found. Check the name again.
The error can occur because of any of the following reasons:
- The login does not exist in the active directory.
- The domain controller is unavailable.
- You are not using BUILTIN as the domain name when adding a local account.
- Name resolution issues.
Review the following sections for actions you can take for each of the different causes mentioned above.
Verify the login you are trying to add
- Verify that the Windows login still exists in the domain. Your network administrator may have removed the Windows login for specific reasons, and you may not be able to grant that login access to the SQL Server.
- Verify that you are spelling the domain and login name correctly and that you are using the following format:
- If the login exists, and it is correct, and you still receive the error, continue with the following sections in this article.
Verify if the domain controller is available
You might receive error 15401 when the domain controller for the domain where the login resides (the same or a different domain) is not available for some reason.
If the login is in a different domain than the SQL Server, verify that the correct trusts exist between the domains.
Verify that the domain controller of the login is accessible by using the ping command from the computer that is running SQL Server. Check both the IP address and the name of the domain controller.
Verify the domain name for local accounts
Local (non-domain) accounts require special handling. If you are trying to add a local account from the local computer that is running SQL Server, ensure you are using BUILTIN as the domain name.
Check for name resolution issues
If you have problems resolving the name of a computer that is involved in adding the login or group, you might receive error 15401.
Verify that your name resolution mechanism (such as, WINS, DNS, HOSTS, or LMHOSTS) is configured correctly.