Learn the necessary credentials or permissions to prevent issues during OfficeScan / Apex One database migration via SQL tool.
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, download the SQLTxfr.chm file.