Make sure that you have the following authentication credentials when using the Windows Account to log on to the server.

• For local account that meets all the following conditions:
  • Belongs to the local administrator group or Active Directory (AD) built-in administrator
  • User roles: Log on as a service, Log on as a batch job, and Log on locally
   

  In some environments, service accounts are being restricted to log on locally. Make sure that the local account used is not listed in the Security Setting for Deny log on locally, Deny log on as a service and Deny log on as a batch job. If a user is in both "Allow log on locally" policy and "Deny log on locally" policy, Deny policy is followed, so user account will be unable to connect to the SQL database.

  

• For SQL server account:

  Database roles: dbcreator, bulkadmin, and db_owner

For more information on using SQL Migration Tool, refer to this documentation.