If you need restrictive permissions for the external database user and want to create the database before running the migration tool, use the advanced configuration option.
This section describes the guidelines for independently creating an external MSSQL database.
If you choose to create the database on your own, these conditions must be met:
You need to create two databases, named SNTRSRV and SNTRSRV_BACKUP, respectively.
On each database, enable the READ_COMMITTED_SNAPSHOT, transaction isolation level by running these commands:
ALTER DATABASE SNTRSRV SET READ_COMMITTED_SNAPSHOT ONALTER DATABASE SNTRSRV_BACKUP SET READ_COMMITTED_SNAPSHOT ON
Both databases should be owned by the user created for the Database Security server, for example, DBSS.
The user must be the dbowner who has all permissions for the databases.