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
Read the rest

SQL Server Error : 10028, Severity: 16. Authentication failed.

SQL Server Error : 10028 Details

SQL Server Error: 10028 Severity: 16 Event Logged or not: No Description: Authentication failed. Severity 16 Description: Indicates general errors that can be corrected by the user.

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.htmlRead the rest

SQL Server Error : 10027, Severity: 16. Command was not prepared.

SQL Server Error : 10027 Details

SQL Server Error: 10027 Severity: 16 Event Logged or not: No Description: Command was not prepared. Severity 16 Description: Indicates general errors that can be corrected by the user.

Has anyone managed to connect to Windows Search Service using SQL Server’s OLE DB Provider for Search? The error message I keep getting when setting a Linked Server in Management Studio is listed above…

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 … Read the rest

SQL Server Error : 10026, Severity: 16. No command text was set.

SQL Server Error : 10026 Details

SQL Server Error: 10026 Severity: 16 Event Logged or not: No Description: No command text was set. Severity 16 Description: Indicates general errors that can be corrected by the user.

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 … Read the rest

SQL Server Error : 10024, Severity: 16. The provider indicates that the user did

SQL Server Error : 10024 Details

SQL Server Error: 10024 Severity: 16 Event Logged or not: No Description: The provider indicates that the user did not have the permission to perform the operation. Severity 16 Description: Indicates general errors that can be corrected by the user.

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 … Read the rest

SQL Server Error : 10011, Severity: 16. Access denied.

SQL Server Error : 10011 Details

SQL Server Error: 10011 Severity: 16 Event Logged or not: No Description: Access denied. Severity 16 Description: Indicates general errors that can be corrected by the user.

Error: 10011, Access denied when trying to add new server roles to users. I’m using Windows Server 2008 so I run SSMS as an administrator. I’m using Mixed Mode and logging in as “sa” when I get this error. Tried with Windows Integrated as well, even after uninstalling and reinstalling.

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 … Read the rest

SQL Server Error : 8533, Severity: 20. Error while waiting for communication fr

SQL Server Error : 8533 Details

SQL Server Error: 8533 Severity: 20 Event Logged or not: No Description: Error while waiting for communication from Kernel Transaction Manager (KTM): %d. Severity 20 Description: Indicates that a statement has encountered a problem. Because the problem has affected only the current task, it is unlikely that the database itself has been damaged.

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
Read the rest