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

Create a technical support case if you need further support.

Migrating HTTPDB to SQL server using Windows Account fails in OfficeScan (OSCE) 11.0

    • Updated:
    • 23 Sep 2016
    • Product/Version:
    • OfficeScan 11.0
    • Platform:
    • Windows 2012 Standard R2
Summary

When trying to migrate the OSCE HTTPDB codebase database to an SQL server using the SQLTxfr tool, it fails to complete if a Windows Account is used, even though the Windows Account passes the Test Connection process. However, when using an SQL Server Account, the HTTPDB database is migrated successfully.

Upon checking the Ofcdebug.log, the following entries can be seen:

2016 09/05 12:51:00 [0e84 : 105c] (00) (D) [][oscedbt.exe]CSqlServerEnvironmentChecker::CheckSqlServerExisted - GetSqlInstanceName failed. - [setup_SqlServerSetup.cpp(861)] 
2016 09/05 12:51:00 [0e84 : 105c] (00) (D) [][oscedbt.exe]CSqlServerEnvironmentChecker::CheckSqlServerExisted - <<< - [setup_SqlServerSetup.cpp(872)] 
2016 09/05 12:51:00 [0e84 : 105c] (00) (D) [][oscedbt.exe]checkLocalSQLEnvironment - No existed SQL Server instance. - [sqltool.cpp(1404)]

These errors occur because when the User Account Control (UAC) settings are adjusted using the UAC slider in the Control Panel of Windows Server 2012 R2, it does not completley turn off the UAC.

Details
Public

To resolve the issue:

  1. Open Local Group Policy on the OfficeScan server and change the following setting:

    gpedit.msc

  2. Navigate to Local Computer Policy > Computer Configuration > Windows Settings > Security Settings > Local Policies > Security Options.
  3. Set the “User Account Control: Run all administrators in Admin Approval Mode” setting to Disabled. The system will then prompt the user to reboot in order for the setting to take effect.

Once that is completed, the migration should succeed when using the specified Windows Account.

Premium
Internal
Rating:
Category:
Troubleshoot; Migrate
Solution Id:
1115251
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.


Need More Help?

Create a technical support case if you need further support.