SQL Server Error : 15401, Severity: 11. Windows NT user or group ‘%s’ not found.

SQL Server Error : 15401 Details

SQL Server Error: 15401
Severity: 11
Event Logged or not: No
Description:
Windows NT user or group ‘%s’ not found. Check the name again.
Severity 11 Description:
Indicates that the given object or entity does not exist.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

For other ways to read and find error log location please our article https://sqlserver-dba.co.uk/error-log/sql-server-identify-location-of-the-sql-server-error-log-file.html

Solution for Resolving the Error

1. Click Start-> Run on the SQL Server running Windows 2008 R2 and input the command GPEDIT.MSC. The Policy Editor will appear.
2. Expand “Computer configuration” – > Windows Settings -> Security Settings -> Local Policies -> Security Options from the Policy Editor.
3. All security policies are displayed in the right-hand window. Make the following two policies adjustments.
4. Domain member: Encrypt secure channel data digitally (when possible) – Turn off this policy
5. Domain participant: Secure channel data should be digitally signed (when possible) – Turn off this policy
6. Close the policy editor and reboot the box after making these changes. (Not SQL Server, but the entire system should be restarted.)
7. Also, have you checked the event log and SQL Server error log to see if there is a problem with SQL Server and Active Directory domain communication?
8. SQL Server Error Code and solution summary

SQL Server Error: 15401
Severity: 11
Event Logged or not: No
Description:
Windows NT user or group ‘%s’ not found. Check the name again.