Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Required permissions to migrate OfficeScan/Apex One database using SQL migration tool

    • Updated:
    • 26 Oct 2020
    • Product/Version:
    • Apex One All
    • OfficeScan 11.0
    • OfficeScan XG
    • Platform:
    • N/A
Summary

Learn the necessary credentials or permissions to prevent issues during OfficeScan / Apex One database migration via SQL tool.

Details
Public

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.

Premium
Internal
Partner
Rating:
Category:
Migrate
Solution Id:
1103572
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.