MS SQL Runtime Edition Licensing and Sage 300 ERP

ms-sql-server-licensing

Beginning with MS SQL Server 2008 R2, Sage software began to offer a Microsoft SQL Server Runtime Edition for its Sage 300 partner base. The only difference between this version of MS SQL and the one you buy from say Amazon is that it costs less and it can only be used with Sage 300 AND its related applications. What is a related Sage 300 application? Sage CRM (Customer Relationship Management), Sage HRMS (Human Resource Management) and Sage FAS (Fixed Asset Software) are all considered related applications. Any 3rd party add-on to Sage 300 also qualifies. So products like Auto Simply (AutoSimply) manufacturing, ACCU-Dart, DingoSoft, Sage Payment Solutions, EC Internet, Norming Asset Management, you get the picture, all qualify because they are tightly integrated to the Sage 300 architecture and/or the Sage 300 database.

There are no differences between the MS SQL Standard Edition and the Runtime Edition other than what I just mentioned above.

There are differences in the MS SQL Express Edition (free) and the Runtime Edition and the Standard Edition in that MS SQL Express accommodates a limited database size and MS SQL Express can only accommodate up to five users. Microsoft does not recommend using MS SQL Express for anything other than a testing database. The Runtime and Standard Editions have unlimited database size and you can purchase as many user licenses as needed.

There are benefits to the MS SQL Runtime Edition and it is mainly price related. The MS SQL Runtime Edition user (called a CAL) is going to set you back $175.00 per CAL, whereas the MS SQL Standard Edition Server could be as high as $4,000.00 and that’s just for the server, you still have to purchase CAL’s. Things can also get very pricey if you are required to purchase licensing based upon the core processors in your server hardware too. In the old days, Microsoft treated a dual/quad core processor as a single processor, no matter the number of cores in your server. Not with newer versions of MS SQL Server!

What’s ahead for versions of MS SQL Server 2014 and beyond? Independent Software Vendors (ISV’s) are seeing a change in the price of their partnership with Microsoft and a licensing policy change for active-passive SQL server clusters. All of this will, of course, trickle down to the end-user. While Microsoft wishes everyone would move to Azure, we’ve noticed our customer base are not all that eager to move into the cloud.

Tags: ,