Symptom
Many Microsoft SQL Server Logins and users are created in the SQL Server by SAP Software provisioning Manager in SAP Java system installation. During the creation of the SQL logins, required server roles and user mappings for the SAP system are also set for the SAP Database and System databases.
It is very important not to change any of the properties set for SQL server logins and users created for SAP system as the proper Server roles and user mapping are required for the operation of the SAP system in SQL Server.
If any of the SQL login properties are modified, then the SAP system will have many problems including the starting of the SAP system. In addition, there will be problems in future SAP upgrades, SQL server release upgrades and any other SWPM procedures.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
SAP NetWeaver Java and Microsoft SQL Server
Product
Keywords
SQL Server , Logins , Users , server roles, SWPM , sid , <SID> , SAPService<SID> , <sid>adm , <sid>, Java , 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.