Solution : https://service.sap.com/sap/support/notes/610640 (SAP Service marketplace login required)
Summary :
SAP Note details restoring SQL Server databases onto new servers or system copies, necessitating the creation of new SQL Server logins. Post-restoration, SQL Server logins must be set up anew to maintain access controls, complicated by MCOD usage and schema integration. Former procedures such as sp_check_sap_login are unsupported, replaced by SCHEMA4SAP.VBS (Note 1294762) to manage these tasks effectively.
Key words :
create sql server logins, sql server logins, vb script schema4sap, stored procedure sp_check_sap_login, sql server, terms mcod, sp_change_users_login reason, database restore, system copy, trivial matter
Related Notes :
| 1294762 | SCHEMA4SAP.VBS |
| 806925 | SQL Error 4064: Cannot open user default database |
| 683447 | SAP Tools for MS SQL Server |
| 551915 | R/3 won't start after database restore or database copy |