x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 44 subscribers
  • Views 1043 views
  • Users 0 members are here
Browse Forums
Announcements
68
topics
93
replies
Customization and Integration
262
topics
822
replies
Financials, Projects, and Administration
382
topics
843
replies
General Discussion
327
topics
836
replies
Installation and Technical Issues
335
topics
1k
replies
Manufacturing, Distribution, and Applications
341
topics
696
replies
Reporting and Analytics
123
topics
480
replies
Ostrem

SQL Server 2022 Compatibility

SUGGESTED
Posted By

Hello,

We are purchasing new hardware to replace our outdated server. Does anyone know if the latest version of Sage 500 will be compatible with SQL Server 2022. I like to believe that there won't be any issues but you never know. Has anyone been running it on 2022? I tried installing the developer edition to run a test database but Sage refused to run on anything other than a production version of SQL.

Thanks in advance.

Jason

  • 0

    Jason,

    Sage 500 Version 2023 was release shortly before SQL 2022 was release so as of the 2023 base release it was not supported.  We are currently adding the support of SQL 2022 to version 2023. This should be in a PU coming in the near future. (not the Jan 2023 PU but expecting to be the one after that)

    The main area that will have issues whenever a new SQL server is released is the Data Import Manager area, they are reliant on the SSIS dlls that are delivered with SQL Server and need to be utilized with the Data Import DLLs.

    Hope this helps,

    Kevin

  • 0 in reply to kkeller

    Thanks for the quick reply Kevin.

    Since I am just moving (restoring) my existing database over to a newer version of SQL would it work? I guess I'm wondering if I could restore the database on SQL Server 2022 and run it in compatibility mode if I had to. It just was bad timing on the release of 2022 and my upgrade. I don't want to be purchasing new SQL software and licensing twice. If it won't work, I guess I'll just move my existing SQL VM to the new server until the compatibility is official.

    Jason

  • 0 in reply to Ostrem

    Safest bet would be to wait for the SQL 2022 support. I have run on SQL 2022 from a high level (no Data Importing) but have not done the compatibility testing to see if anything creeps up.

    Kevin

  • 0 in reply to Ostrem
    SUGGESTED

    I'm not sure if this is still relevant, but for others searching this issue; when you buy SQL server licensing, it typically includes a previous version key. You will have ownership of both 2019 and 2022 when you purchase the 2022 license. Confirm with your reseller before purchase.

*Community Hub is the new name for Sage City