Imperva Cyber Community

communities_1.jpg
 View Only

  • 1.  Imperva Agent Error After Latest MS SQL Patch – "Agent does not support this MSSQL version"

    Posted 2 days ago

    Hello Everyone,

    We are facing an issue with the Imperva Database Agent after applying the latest Microsoft SQL Server patch on our database environment.

    Post database patching, the Imperva agent started reporting errors. Based on the Imperva Data Coverage Tool, we observed the following message:

    Error Message:

    Agent does not support this MSSQL version

    What we have done so far

    • The MS SQL Server was patched to the latest available version.
    • After noticing the issue, we upgraded the Imperva agent to the version recommended by the Data Coverage Tool.
    • The agent upgrade was completed successfully.
    • However, even after the upgrade, we are still facing the same error and the database continues to show as unsupported.

    Current Situation

    • Database is running without any issues.
    • Imperva agent service starts but remains in an error state.
    • in Agent Activity it remains as the "Agent does not support this MSSQL version"

    Looking for Guidance

    At this point, we would appreciate any insights or experiences from the community:

    • Has anyone faced a similar issue after patching MSSQL?
    • Is there a known compatibility gap between the latest MSSQL patches and certain Imperva agent versions.

    Any suggestions, shared experiences, or recommendations would be greatly appreciated.

    Thank you in advance for your time and support.


    #DatabaseActivityMonitoring

    ------------------------------
    Bhuvan Shyam M
    Admin
    Karnataka Bank Ltd.
    ------------------------------


  • 2.  RE: Imperva Agent Error After Latest MS SQL Patch – "Agent does not support this MSSQL version"

    Posted 2 days ago

    Yo need to install the latest ACP

    The latest ACP version

    • 869.0.1042 

     cover all these new MSSQL versions

    • Added support for the below MSSQL versions when using Advanced Mode Monitoring: 
      • Added support for: Microsoft SQL Server 2016 64-bit    Product Version 13.00.6480.4 
      • Added support for: Microsoft SQL Server 2016 64-bit    Product Version 13.00.7075.5 
      • Added support for: Microsoft SQL Server 2017 64-bit    Product Version 14.00.2100.4 
      • Added support for: Microsoft SQL Server 2017 64-bit    Product Version 14.00.3520.4 
      • Added support for: Microsoft SQL Server 2019 64-bit    Product Version 15.00.2160.4 
      • Added support for: Microsoft SQL Server 2019 64-bit    Product Version 15.00.4460.4 
      • Added support for: Microsoft SQL Server 2022 64-bit    Product Version 16.00.1170.5 
      • Added support for: Microsoft SQL Server 2022 64-bit    Product Version 16.00.4240.4 
      • Added support for: Microsoft SQL Server 2022 64-bit    Product Version 16.00.4245.2 
      • Added support for: Microsoft SQL Server 2025 64-bit    Product Version 17.00.1000.7 
      • Added support for: Microsoft SQL Server 2025 64-bit    Product Version 17.00.1050.2 


    ------------------------------
    Alejandro Hernandez
    SICAP
    Professional Services Consultant and Principal Technical Trainer
    Mexico City
    ------------------------------

    Original Message


  • 3.  RE: Imperva Agent Error After Latest MS SQL Patch – "Agent does not support this MSSQL version"

    Posted yesterday

    Hi Alejandro,

    Thank you very much for the clarification and for sharing the details about the latest ACP version 869.0.1042.

    After reviewing the information, I can confirm that this version covers all the required MSSQL versions listed, including SQL Server 2016, 2017, 2019, 2022, and 2025 when using Advanced Mode Monitoring. Based on this, the concern I raised earlier is now resolved.

    I appreciate your quick response and support.

    Thanks again for your help.



    ------------------------------
    Bhuvan Shyam M
    Admin
    Karnataka Bank Ltd.
    ------------------------------

    Original Message


  • 4.  RE: Imperva Agent Error After Latest MS SQL Patch – "Agent does not support this MSSQL version"

    Posted 2 days ago

    Hi Bhuvan,

    Please ensure that agent installation manager is installed along with the agent otherwise uploading the latest ACP on MX will not be delivered to it. Secondly, you may compare the version of database installed using the command given in the MS documentation https://learn.microsoft.com/en-us/sql/t-sql/functions/version-transact-sql-configuration-functions?view=sql-server-ver17 to the versions which are given in the attachment of the KB article: https://docs-cybersec.thalesgroup.com/bundle/z-kb-articles-knowledgebase-support/page/290718678.html to understand whether it is covered or not.

    Regards,



    ------------------------------
    SBISOC 4430
    Manager
    Mumbai
    ------------------------------

    Original Message


  • 5.  RE: Imperva Agent Error After Latest MS SQL Patch – "Agent does not support this MSSQL version"

    Posted yesterday

    Hi Team,

    Thank you for the detailed guidance and clarification.

    We will ensure that the Agent Installation Manager (AIM) is installed along with the agent so that the latest ACP uploaded on MX can be properly delivered. We will also verify the installed database version using the command referenced in the Microsoft documentation and compare it against the supported versions listed in the attached KB article to confirm coverage.

    This information is very helpful. We'll proceed accordingly and reach out if any further clarification is required.

    Thanks again for the support.



    ------------------------------
    Bhuvan Shyam M
    Admin
    Karnataka Bank Ltd.
    ------------------------------

    Original Message