Outdated or expired credentials can break the connection between Apex One Server and SQL Server. Follow the steps to update the credentials used to connect to the SQL database:
- On the Apex One server, go to <Server installation folder>\PCCSRV\Admin\Utility\SQL.
- Double-click SQLTxfr.exe.
- Specify the Server name as follows: <hostname or IP address of the SQL Server>\<instance name>
The Server and Database name can be found under [DBServer] section of ..\PCCSRV\Private\ofcserver.ini.
- Provide the authentication credentials for the SQL Server database.
You can check the [DBServer] section of ..\PCCSRV\Private\ofcserver.ini to know the previous authentication mode used on the SQL Server.
- SQLAuthMode=5020 means SQL Server account
- SQLAuthMode=5030 means Windows account
When using the Windows Account to log on to the server, Apex One applies the username of the currently logged on user.
Make sure that the account has the required roles and permission to log on to the server. For more information, you can refer to Required permissions to migrate OfficeScan/Apex One database using SQL migration tool. - Specify the Apex One Database name on the SQL Server.
- Click Test Connection and check if it will be successful.
If the connection failed, you may refer to this article to further check the issue.
- If the test is successful, click Start to apply the configuration changes.
- Click Yes when asked, to apply the changes.
If the issue persists, collect logs using Case Diagnostic Tool and submit it to Trend Micro Technical Support.
Components that are missing due to accidental uninstallation, or were not included in the SQL Server installation can cause the issue. To resolve the issue, it is possible to perform the repair on the SQL Server installation using the resource files included in the Apex One server Utility folder:
- Run SQL_2016.exe installation located at %Programfiles(x86)%\Trend Micro\Apex One\PCCSRV\Admin\Utility\SQL.
Click the image to enlarge.
- Choose maintenance then click the Repair button.
Click the image to enlarge.
- Select the SQL Instance where the Apex One database is hosted.
- After the successful repair, run the SQLTxFr.exe tool and test the connection. Then if the connection will be successful, click Start.
- After that go to services.msc and start Apex One Master Service.