2449377 - System copy fails with error "[SQL Server] An error was raised during trigger execution"

You are performing a homogeneous system copy.

During the execution of  [Your Product] > MS SQL Server > System Copy > Target System Installation > [System Option] > Based on AS ABAP > Database Instance, SWPM fails with the following error message:

[Microsoft][ODBC SQL Server Driver][SQL Server]profile name is not valid
[Microsoft][ODBC SQL Server Driver][SQL Server]An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back

The following screenshot illustrates the error:

• SAP Systems based on SAP Netweaver;
• Microsoft SQL Server 2008 and higher;

profile name is not valid, the batch has been aborted and the user transaction, if any, has been rolled back, [Microsoft], [ODBC SQL Server Driver], [SQL Server], ODBC SQL Server Driver, SWPM, Software Provisioning Manager, trigger, triggers, homogeneous, backup, restore, attach, dettach, high-availability, Last error reported by the step, , KBA , BC-DB-MSS-INS , SQL Server Installation for SAP NetWeaver Products , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem