SAP Knowledge Base Article - Preview

3036546 - Could not log in SQL Server Management Studio with any DB user

Symptom

  • DB user could not log in SSMS(SQL Server Management Studio) with error 18456 but SSMS could be logged in with Windows authentication 
  • ERROR.log records the error "An attempt to log in using SQL authentication failed. Server is configured for Windows authentication only"
  • Issue occurs after a system copy.


Read more...

Environment

SAP on SQL server

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

18456, SQL Server, authentication , 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.