SAP Knowledge Base Article - Preview

3769052 - login failed (error 18456) and “cannot open user default database” when database is in SINGLE_USER mode in sql server - SAP NetWeaver

Symptom

  • Not able to connect to database via SSMS with error “Cannot open user default database. Login failed.”
  • "Single user" shows next to the database name <SID>.
  • ERRORLOG shows
    Setting database option SINGLE_USER to ON for database '<SID>'.
    Error: 18456, Severity: 14, State: 38.
    Login failed for user '<domain>\<sid>adm'. Reason: Failed to open the explicitly specified database '<SID>'. [CLIENT: <local machine>]
    Error: 18456, Severity: 14, State: 40.


Read more...

Environment

  • SQL Server in SAP NetWeaver Products

Product

SAP enhancement package for SAP ERP all versions

Keywords

error 18456, state 38, state 40, cannot open user default database, login failed for user, failed to open explicitly specified database, single_user, multi_user, sql server, ssms, restore, default database, -m startup parameter, swpm, permissions , 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.