x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 46 subscribers
  • Views 1381 views
  • Users 0 members are here
Browse Forums
Announcements
69
topics
93
replies
Customization and Integration
234
topics
826
replies
Financials, Projects, and Administration
385
topics
846
replies
General Discussion
319
topics
865
replies
Installation and Technical Issues
284
topics
1k
replies
Manufacturing, Distribution, and Applications
262
topics
698
replies
Reporting and Analytics
105
topics
487
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