These are all questions your reseller should be answering for you.

hahahaha

hahahaha

Hi Paula,

Sage 100 Premium includes a bundled version of MS SQL Server 2010.  Response times will be faster if MS SQL and the Sage Application Server are installed on the same system (this is true for all applications as it  eliminates network bandwidth issues)

John Nichols

Sage

Thank you J.   I asked my reseller and received a different answer.  He said we would have to purchase MS Server server and licenses for everyone that accesses MAS.  (20)  He said that they should be on separate servers, as SQL will take up all the performance.   I keep hoping I can get one spec sheet or white paper on the exact requirements and pricing and suggested configuration.  (It's not that easy)

Hi Paula,

Clarification: We bundle MS SQL Server 2008 r2 with Sage 100 Premium.  I 'll post a link with the recommended system requirements.  

John Nichols

Sage

Thank you very much!

Paula when you purchase Sage 100 Premium you have the option of purchasing the SQL licenses at the same time thru Sage at a discounted rate compared to full sql licensing, this is an option and not something that is bundled at no cost.  Also it is a SQL run-time, meaning it is only licensed to be used by Sage products.    So as an organization if you have other software packages or database needs you may be better purchasing SQL Server outside of the runtime.  If not then the Sage runtime version works great.

ok...i think i have FINALLY come to a decision.  I got hold of a tech/mechanic at Sage.  His recommendation is to stick with what we have (Sage 100 Advanced).  The only people who really have a use for the SQL version would definitely need SQL Server.  They probably would have other SQL ERP systems that require SQL and suggested we would also need a staff  DBA.    Thanks everyone, for your information.  I couldn't have done this with this forum!

John (or whoever is reading this), we have a Sage 100 customer looking at this same question.  The SPM for Sage 100 Premium includes specs for Sage products, but does not specify what the db server requirements are for Sage 100 Premium.  Is there any documentation for this?  Is there a recommended configuration for having SQL on a separate server vs the same server as the application?

Look to Microsoft documentation for SQL server requirements.  AFAIK the version you can purchase from Sage is limited to use with Sage 100 only.  If you buy it separately you could potentially use the SQL instance for any unrelated database server needs your organization may have.

SQL can be on the same server as the Sage 100 service and a proper DBA can tune the SQL settings to not consume all the machine resources.  If it's on a separate server be sure to have a super high speed network connection between the machines.