When deploying Vulnerability Protection (VP) license from License Management of Apex Central, the following error message is encountered:
“License deployment was unsuccessful. Vulnerability Protection Service: Unknown Error”
-
Based on the Command Details:
-
Based on ivp_server0.log (C:\Program Files (x86)\Trend Micro\Apex One\iServiceSrv\iVP\):
SEVERE: Retrying for the 3 time(s). com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host LOCALHOST, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191) at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242) at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2369) at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:551) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1963) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at com.trendmicro.ivp.core.Core.initDatabase(Core.java:482) at com.trendmicro.ivp.core.Core.start(Core.java:99) at com.trendmicro.ivp.core.Core.main(Core.java:84) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65) at com.exe4j.runtime.WinLauncher$2.run(WinLauncher.java:96)
-
Test connection from Apex One Server to SQL Server on port 1433 via PowerShell.
Failed Result:
In Apex One’s Database server, ensure its SQL server accepts remote connections over TCP/IP for port 1433. To do this:
- Log into your SQL server through Remote Desktop Connection.
-
Click Start and expand the Microsoft SQL Server folder. Select SQL Server Configuration Manager.
-
Expand SQL Server Network Configuration then click the Protocols for MSSQLSERVER.
-
Right-click TCP/IP and select Properties. Click the IP Addresses tab then scroll down to IPAll. Ensure the TCP Dynamic Ports is blank and TCP Port is set to 1433. Click Apply then OK.
- Restart the SQL Server (MSSQLSERVER) service.
-
Test the connection from the Apex One Server to SQL Server on port 1433 via PowerShell.
Success Result:
Ensure that port 1433 is allowed on your firewall.
Mixed mode authentication should be enabled as well for remote connections.
-
Log in to manage Apex Central and deploy VP license again, it should now display:
Activation Code deployed successfully. Please wait for the specified products to activate the license.