Trend Micro - Securing Your Journey to the Cloud Business
Support
Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Unable to install SQL on Domain Controller using SQL Server Migration Tool for OfficeScan (OSCE)

    • Updated:
    • 24 Nov 2016
    • Product/Version:
    • OfficeScan 11.0
    • OfficeScan 11.0
    • OfficeScan XG
    • OfficeScan XG.All
    • Platform:
    • Windows 2003 Datacenter 64-bit
    • Windows 2003 Enterprise
    • Windows 2003 Server R2
    • Windows 2003 Standard 64-bit
    • Windows 2008 Datacenter
    • Windows 2008 Datacenter 64-bit
    • Windows 2008 Enterprise
    • Windows 2008 Enterprise 64-bit
    • Windows 2008 Server R2 Enterprise
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2008 Web Server Edition
    • Windows 2008 Web Server Edition 64-bit
    • Windows 2012 Datacenter R2
    • Windows 2012 Server Essential R2
    • Windows 2012 Server Essentials
    • Windows 2012 Standard
    • Windows 2012 Standard R2
Summary
OfficeScan 11.0 and OfficeScan XG support migration of the database to SQL via SQL Server Migration Tool. However, issue may occur when you install SQL Server 2008 R2 express and the server is configured as a domain controller.
Details
Public
Based on the Microsoft article Hardware and Software Requirements for Installing SQL Server 2008 R2, it is not recommended to install SQL on a domain controller.
Aside from security restrictions, performance issues may happen when the OSCE server and SQL run on a domain controller.
If this cannot be avoided, here is a workaround to prevent errors during the installation:
  1. Back up the InstallCfgFile.ini file located under ..\<OfficeScan Server Folder>\PCCSRV\Admin\Utility\SQL.
  2. Open the InstallCfgFile.ini file and change SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" to:
    SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"
  3. Save the file.
  4. Reload the SQL Server Migration Tool.
Perform the SQL server installation and migration again.
Premium
Internal
Rating:
Category:
Troubleshoot; Install
Solution Id:
1103808
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.
Related Articles