Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

"License deployment was unsuccessful...” error occurs when deploying Vulnerability Protection (VP) license in Apex One

    • Updated:
    • 8 Apr 2020
    • Product/Version:
    • Apex One All
    • Platform:
    • Windows Server 2012
    • Windows Server 2012 R2
    • Windows Server 2016
    • Windows Server 2019
Summary

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:

    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:

    Failed result via Powershell

Details
Public

In Apex One’s Database server, ensure its SQL server accepts remote connections over TCP/IP for port 1433. To do this:

  1. Log into your SQL server through Remote Desktop Connection.
  2. Click Start and expand the Microsoft SQL Server folder. Select SQL Server Configuration Manager.

    SQL Server Configuration Manager

  3. Expand SQL Server Network Configuration then click the Protocols for MSSQLSERVER.

    Protocols for MSSQLSERVER

  4. 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.

    SQL Server Configuration Manager

  5. Restart the SQL Server (MSSQLSERVER) service.
  6. Test the connection from the Apex One Server to SQL Server on port 1433 via PowerShell.

    Success Result:

    Success Result

     

    Ensure that port 1433 is allowed on your firewall.

    Mixed mode authentication should be enabled as well for remote connections.

     
  7. 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.

Premium
Internal
Partner
Rating:
Category:
Configure; Troubleshoot
Solution Id:
000249715
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.