The recommended login account for creating the database requires SQL authentication and it should have the following roles enabled: 

If you do not want to provide Sysadmin role to the user, db_creator and Public roles are enough. db_creator is required because we may need to create new tables during the upgrade.