Learn the necessary credentials or permissions to prevent issues during OfficeScan 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
- For SQL server account:
Database roles: dbcreator, bulkadmin, and db_owner
For more information on using SQL Migration Tool, download the SQLTxfr.chm file.