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.