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.
To resolve the issue:
- Open Local Group Policy on the OfficeScan server and change the following setting:
gpedit.msc
- Navigate to Local Computer Policy > Computer Configuration > Windows Settings > Security Settings > Local Policies > Security Options.
- 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.