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 03-25-2026 01:35

    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 03-25-2026 09:48

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



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

    Posted 03-26-2026 02:10

    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 03-25-2026 14:41

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



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

    Posted 03-26-2026 02:18

    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


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

    Posted 18 days ago
    Edited by Tim Sneed 18 days ago

    This message started showing up for us this week May 25 or so. Never seen it before in the years of using Imperva DAM, so in this case it seems like the April or May SQL patches, to SQL 2019 and SQL 2022 caused the error. For now waiting too see how many agents do it once all the servers have the same patches and we'll see if a new ACP comes out to address it since we are at the latest ACP as of today and we updated DAM just a month ago.



    ------------------------------
    Tim Sneed
    Systems Solution Engineer
    Michigan Education Special Services Association (MESSA)
    ------------------------------



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

    Posted 15 days ago

    Hi Tim, am particularly interested in this as we've experienced issues with the May 2025 security updates for SQL 2022 as well.

    Just to recap my understanding: -

    If you're using <mssql-advanced-monitoring>1</mssql-advanced-monitoring> in Agent - Advanced Configuration, then you introduce a dependency of correct Agent functioning on ACP updates.

    Each ACP is validated only against specific supported SQL Server builds.

    If you apply a Microsoft security update before the supporting ACP is available then you end up with the dreaded "Agent does not support this MSSQL version".

    Imperva's advice therefore is to coordinate the MSSQL patching with the availability of the ACP that supports that patch level.

    In my opinion that's quite an ask, because the imperative with a critical Microsoft security update may be to deploy it across your SQL Server estate as soon as possible. 

    So it looks like Imperva DAM users are being asked to make a decision to either 

    a) delay the deployment a critical security patch, or 
    b) deploy the patch, and accept that your Imperva DAM agents will be non-functional until the ACP is available

    Here's a specific case: - on May 12th Microsoft released critical security update KB5089900 for SQL Server 2022. The supporting ACP was not released until 1st June. That's a long wait if you go for option b).

    I find it hard to believe that customers are being constrained in their deployment of critical security updates in this fashion, and would be interested to hear how other organisations are managing this situation.



    ------------------------------
    Ghanesh Narine
    Database Administrator
    Royal London Mutual Insurance Society Limited
    London
    ------------------------------

    Original Message


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

    Posted 15 days ago

    Yes this sounds right. I applied the ACP that came out today and the error state is gone. In our case it was only on a few SQL servers since at this point the patches haven't been rolled out to all servers, mostly dev or test environments. It does seem that SQL 2022 is more of an issue than 2019 which is what most of our SQL servers have running for now. We recently updated our Secure Sphere MX, and gateways to 14.19.1.110 and agents to 14.9.0.90.0.657028, so it seems like the older version we were running wasn't bothered by this issue. I agree, that changing the timing of when SQL updates are applied to our servers isn't and likely solution and if it's similar next time where it's only a few servers before the ACP is updated, we'll probably live with it. Thanks for the reply, it was good to see the similar issues and explanation. 



    ------------------------------
    Tim Sneed
    Systems Solution Engineer
    Michigan Education Special Services Association (MESSA)
    ------------------------------

    Original Message