SAP Knowledge Base Article - Preview

3236939 - SQL Server Error 18456- Login failed for user

Symptom

Contains the detailed error state for ERRORLOG 18456.
Confirm the error state to determine the reason for the login failure.

For example(ERRORLOG)
2022-06-27 02:00:40.60 Logon Error: 18456, Severity: 14, State: 38.
2022-06-27 02:00:40.60 Logon Login failed for user 'SYSTEM**'. Reason: Failed to open the explicitly specified database 'DB**'. [CLIENT: <local machine>]


Read more...

Environment

SQL Server

Keywords

authentication error, login failure, internal processing error, TRUSTED_CONNECTION, Mixed Authentication Mode , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.