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:
- What is the difference between Windows authentication and SQL Server authentication?
- Which logins are used by an SAP system?
- How does an ABAP work process connect to the database?
- How does a Java process connect to the database?
- How do I change the password of SQL Server login
- sa
- <sid>
- SAP<SID>DB
- 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.