SAP Knowledge Base Article - Preview

3194016 - SQL Server Logins and users created in the SQL Server by SAP Java installation.

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

SAP NetWeaver Application Server for Java all versions

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.