Account Creation Failure for a Microsoft SQL Server Database Migrated from Alibaba Cloud to Huawei Cloud

Description

An error was reported when an account was created for a Microsoft SQL Server database migrated from Alibaba Cloud to Huawei Cloud.

Fault Analysis

The Microsoft SQL Server database on Alibaba Cloud has a TGR#ON#DATABASE trigger that prevents SQL Server Management Studio from creating and authorizing users. Database users can only be created on the Alibaba Cloud management console. On Huawei Cloud, database users can be created using SQL Server Management Studio.

Before migrating a Microsoft SQL Server database from Alibaba Cloud to Huawei Cloud, you need to disable the TGR#ON#DATABASE trigger of Alibaba Cloud first and then create and authorize database users on SQL Server Management Studio.

1. Log in to the SQL Server Management Studio client.
2. Set TGR#ON#DATABASE to disable.

   

3. Create database users on SQL Server Management Studio and authorize them.
   

   The new user authorization must be mapped to the msdb database.