You have specified Sage 300 Pro, but I'm assuming (hopefully) that you mean Sage 200 Professional.  With that specification we would suggest SQL Server 2022  Standard Edition.  If you have a small database, you may get away with SQL Express but this does have a memory limit of 1GB and a maximum database size of 10GB.  Normally we wouldn't suggest this for a live environment though.

If the SQL server is going to used SOLELY for the Sage 200 database then you could purchase a runtime SQL licence from Sage, if this is for a new Sage 200 licence.  If not, then you would require the SQL Standard Edition.

The above assumes it is for an on-premise solution.

Hope it helps.

Hi Steve, many thanks for the reply,  That was a typo, was meant to be Sage 200 Pro.

Our current Sage Database is 3.5GB, and the (new and existing) servers are both Cloud-Hosted, and the new server is exclusively for Sage.

A support company that I spoke with, suggested 5 X SQL 2022 server CAL licences, and 1 X SQL Server Standard Edition "Perpetual" Licence - does this sound correct ?

I was not aware that we can purchase MS SQL licences from Sage, maybe I should take this route, if I do, do I just log a call with yourselves ?

Thanks.

Yes, I would agree with the quantity of licences suggested by your support company.

There are a number of different ways you can purchase the SQL licence; Open Value Licence from a Microsoft Partner which has the option for upgrades in the future (if you include software assurance), CSP licence which would allow you to purchase on annual/monthly recurring basis and may include upgrade rights, or Perpetual which tends to be the 'cheaper' option but doesn't allow you to upgrade to a later release in the future.  The licence from Sage is ONLY for a new purchase and has restrictions on it's usage, but does include the software assurance to allow for upgrades.

Yes, I would agree with the quantity of licences suggested by your support company.

There are a number of different ways you can purchase the SQL licence; Open Value Licence from a Microsoft Partner which has the option for upgrades in the future (if you include software assurance), CSP licence which would allow you to purchase on annual/monthly recurring basis and may include upgrade rights, or Perpetual which tends to be the 'cheaper' option but doesn't allow you to upgrade to a later release in the future.  The licence from Sage is ONLY for a new purchase and has restrictions on it's usage, but does include the software assurance to allow for upgrades.

Hi steve. Many thanks for the information, that is very useful.