Component : Microsoft SQL Server -

Solution : https://service.sap.com/sap/support/notes/592514 (SAP Service marketplace login required)

Summary :
This SAP Note outlines specific user and login requirements for SAP installations using Microsoft SQL Server. Essential users include SAPServiceSID, sidadm, and SAPMssXPUser, each assigned varying server roles and responsibilities. For database connectivity, SAP uses integrated security, strongly discouraging SQL logins in ABAP-based environments, while necessary for Java-based applications. The note highlights the importance of secure configurations and references a VB script in note 1294762 for managing SQL logins. Additional guidelines for managing and securing database logins such as 'sid' and 'SAPDB' are provided, particularly noting the security configurations during upgrades or routine operations.

Key words :
integrated security java-based sap applications require sql logins, xp_cmdshell sql extended stored procedure, bulk insert administrator               database roles, sap java application server, note sid means sapsid, automaticaly generated               server roles, sap<sid>db user, sap database               default database, java application server, java upgrade program

Related Notes :

1294762

SCHEMA4SAP.VBS