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

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!