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
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:
- Back up the InstallCfgFile.ini file located under ..\<OfficeScan Server Folder>\PCCSRV\Admin\Utility\SQL.
- Open the InstallCfgFile.ini file and change SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" to:
SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"
- Save the file.
- Reload the SQL Server Migration Tool.
Perform the SQL server installation and migration again.