While installing TMSM in Windows Server 2012 or 2012 R2 with domain controller role, you encounter the following error message:
Error: An error in the Plug-in Service program occurred. Unable to install the Trend Micro Security (for Mac) server. An error occurred during the installation of Microsoft SQL Server Express. To resolve the issue, refer to https://success.trendmicro.com/solution/1101931-security-for-mac-tmsm-2-1-server-cannot-be-installed-in-windows-server-2012-or-2012-r2-with-domain-controller-role-in-worry-free-business-security-wfbs-.
SQL Server 2008 or 2008 R2 Express cannot use a network service account to create an instance in Windows Server 2012 or 2012 R2 with domain controller role. Microsoft does not recommend installing an SQL server on a domain controller. However, the SQL installation is not blocked.
As a workaround, do either of the following:
Option 1
- Install the WFBS server on the domain controller computer.
- Download the InstallCfgFile.zip file and extract under the ..\Trend Micro\Security Server\PCCSRV\Admin\Utility\SQL\ folder.
- Download then install the TMSM server on the domain controller computer.
Option 2
Install the Security Server and TMSM server on Windows SBS 2011 or lower operating systems, or other Windows 2012 or 2012 R2 without domain controller role. For security reasons, Microsoft does not recommend installing the SQL Server on a domain controller. For more information you can refer to the Microsoft article: Hardware and Software Requirements for Installing SQL Server 2008 R2.