Sage Fixed Assets version 2024.1 system requirements for SQL server 2016

SOLVED

Hi,

I am upgrading my Sage Fixed Assets Premier client this weekend from version 2022.1 to 2023.1 then 2024.1. The system requirements for version 2024.1 state MS-SQL server must be at SP3 but the client is only on SQL version 2016 SP2 will 2024.1 work once upgrade is completed? If not do you know what issues i will have?

Thank you!

Parents
  • 0
    verified answer

    Hello Suegeek,

    The whole issue with the Service packs on the SQL server revolves around the recent disabling for the TLS 1.0 and 1.2 protocols where you must be on MS SQL server 2014 sp2 at the minimum to be able to connect with just the TLS 1.2 enabled.

    As far as I know, any version of SQL 2016 can do that, so I do not know of any reason the SQL 2016 sp2 will not work, but it is just not supported.

    On a side note, remember to convert the databases in between each installation, see How do I convert data for more information.

    ~Delray

Reply
  • 0
    verified answer

    Hello Suegeek,

    The whole issue with the Service packs on the SQL server revolves around the recent disabling for the TLS 1.0 and 1.2 protocols where you must be on MS SQL server 2014 sp2 at the minimum to be able to connect with just the TLS 1.2 enabled.

    As far as I know, any version of SQL 2016 can do that, so I do not know of any reason the SQL 2016 sp2 will not work, but it is just not supported.

    On a side note, remember to convert the databases in between each installation, see How do I convert data for more information.

    ~Delray

Children
No Data