SAP Knowledge Base Article - Preview

1645041 - FAQ: Microsoft SQL Server logins and their usage in SAP environment

Symptom

To meet certain security requirements (e.g. Sarbanes Oxley = SOX) you need to change the password of one or more MS SQL Server logins. You want to know in which way this affects your SAP systems and which steps are required on SAP-side.

This KBA clarifies the following questions:

  1. What is the difference between Windows authentication and SQL Server authentication?
  2. Which logins are used by an SAP system?
  3. How does an ABAP work process connect to the database?
  4. How does a Java process connect to the database?
  5. How do I change the password of SQL Server login
    1. sa
    2. <sid>
    3. SAP<SID>DB
  6. Does my SAP system need/use the Windows BUILTIN\Administrators group login within SQL Server?


Read more...

Environment

  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Micorosft SQL Server 2017
  • Microsoft SQL Server 2019
  • SAP NetWeaver Application Server for ABAP, All versions
  • SAP NetWeaver Application Server for Java, All versions

Product

SAP NetWeaver Application Server for ABAP all versions ; SAP NetWeaver Application Server for Java all versions

Keywords

KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , How To

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.