3156723 - SQL Server Logins and users created in the SQL Server by SAP ABAP installation.

Symptom

During the installation of SAP system, many SQL Server Logins and users are created in the SQL Server by SAP Software provisioning Manager. 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.

Product

SAP NetWeaver Application Server for ABAP all versions

Keywords

SQL Server , Logins , Users , server roles, SWPM , sid , <SID> , SAPService<SID> , <sid>adm , <sid> , 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.