Summary
Messaging Security Agent (MSA) installation fails at SQL Express 2005 installation stage.
You encounter the following error message:
...Cannot start SQL Server service. Ensure the domain administrator account has privilege to modify the database and/or the date of the system is correct...
Details
The following may cause the installation to fail:
Before MSA is installed, the target exchange server has existing SQL instances (e.g. SQL application for database management).
To resolve the issue:
- Check if the account used has domain administrator privilege.
- Check if there are remnants of previously failed MSA installation. To do this, please do the following:
- Extract MSA Uninstall Tool. Type "novirus" when prompted for a password.
- Run the Luncher.js as administrator.
- Click Check on the MSA Uninstall Tool interface.
- When all checkpoints' results are "Passed", proceed to the next steps. Otherwise, click Clean to remove all MSA remnants.
- Extract MSA Uninstall Tool.
- Install the SQL SCANMAIL instance manually.
For WFBS 8.0 and below
- If the SQL Server instance has SQL Server Express 2005 Service Pack 2 installed, download the SQL 2005 Express Service Pack 3 and go to Step 4.
- If the SQL Server instance has no SQL Server Express 2005 Service Pack 2, go to the following directory to get the SQL 2005 Express install package from the Security Server:
\Security Server\PCCSRV\MSA\x64\SQL2005Express\
For WFBS 9.0
- Download the SQL 2008 R2 Express Service Pack 3.
- If the SQL Server instance has no SQL Server Express 2008 R2 Service Pack 3, go to the following directory to get the SQL 2008 Express install package from the Security Server:
\Security Server\PCCSRV\MSA\x64\SQL2008Express\
For WFBS 9.5
On Windows Server 2012 or higher
- Download the SQL Server 2014.
- If the SQL Server instance has no SQL Server, go to the following directory to get the SQL 2014 install package from the Security Server:
\Security Server\PCCSRV\MSA\x\SQL2008Express\
On Windows Server 2008
- Download the SQL 2008 R2 Express Service Pack 3.
- If the SQL Server instance has no SQL Server Express 2008 R2 Service Pack 3, go to the following directory to get the SQL 2008 Express install package from the Security Server:
\Security Server\PCCSRV\MSA\x64\SQL2008Express\
- Run the SQLEXPR*.exe on the target exchange server.
- On the Registration Information window, uncheck the Hide advanced configuration options box.
- On the Feature Selection window, select the Will be installed on local hard drive option for the following components:
- Database Services
- Data Files
- Shared Tools
- Client Components
- Connectivity Components
- Database Services
- On Instance Name window, enter "SCANMAIL" under Named Instance.
- On Service Account window, select Use a domain user account and enter the account with Domain Administrator privilege.
- Proceed installing using the default settings.
- Reinstall MSA. For reference, refer to the following KB article:
Installing the Messaging Security Agent (MSA) from the Worry-Free Business Security (WFBS) Advanced consoleMake sure the user is logged on as administrator while installing.
