Symptom
During the execution of a Database Refresh or System Copy, SWPM fails with the following error message: "Server Principal 'DOMAIN\sidadm' already exists".
You can find more details in the sapinst_dev.log file:
ERROR 2017-05-23 16:32:20.928 (DOMAIN\sapinstaller) [D:/depot/bas/749_REL/bc_749_REL/src/ins/SAPINST/impl/src/dbmodmss/iaxmbcom.cpp:118] id=dbmodmssql.odbcdll.sql errno=MDB-05053 CMssLogger::logMessage
Errors when executing sql command: [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared
[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal 'DOMAIN\sidadm' already exists.
<p> SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support. </p>
Read more...
Environment
- SAP systems based on SAP NetWeaver;
- Microsoft SQL Server 2008 and higher;
Product
Keywords
Associated statement is not prepared, Server Principal, exist, exists, mssql, ms sql, msql, ms_sql, sqlserver, sqlservr, refresh, copying, installing, error during, error while, after installing, SWPM, Software Provisioning Manager, failed to install , KBA , BC-DB-MSS-INS , SQL Server Installation for SAP NetWeaver Products , BC-INS , Installation Tools (SAP Note 1669327) , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-INS-NT , SAP Netweaver based Solutions on Windows , BC-OP , Operating System Platforms , Problem
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.
SAP Knowledge Base Article - Preview