Sage 100

 View Only
  • 1.  SQL: Sage Runtime CAL vs Full SQL license - Any Change In What You Recommend?

    Posted 02-06-2024 08:55

    I'm not particularly eager to get involved in the setup or maintenance of SQL Server. It's not my skill set, and I think customers need internal staff or MSPs supervising their networks. However, some companies - typically those with fewer technical resources - still ask whether buying the Sage Runtime CAL SQL ( $120/user) vs the full SQL licenses makes sense.

    I'm also aware this question gets asked a LOT in this group. So I apologize for asking again. Ideally, I'd like to see if anything has changed that might cause me to recommend one type of - SQL ( Runtime CAL ) vs full SQL licenses.

    Questions

    1. Do you recommend the Runtime CAL SQL over full SQL? When and why? Any broad guidelines on price ( I realize this varies based on the customer's relationship with Microsoft).
    2. What are the pros and cons of the Sage Runtime CAL SQL? One con is that you cannot use the runtime SQL in a hosted environment.
    3. How many users of SQL do you recommend that customers license for a 10-user Sage 100 Premium.

    TIA



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------


  • 2.  RE: SQL: Sage Runtime CAL vs Full SQL license - Any Change In What You Recommend?

    Posted 08-26-2025 15:11

    Don't all chime in at once.  I need to get a quote for SQL server.  One of my customers wants to move to Premium.  Their IT company sucks so it's easier to install SQL myself.  Any suggestions for a 15 user Sage 100 system?  How many SQL licenses to they need?  Should I get them through Sage?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: SQL: Sage Runtime CAL vs Full SQL license - Any Change In What You Recommend?

    Posted 08-26-2025 15:36

    Doug,

    Take a look as this document - 2025-07-26-  What Are The Configuration Settings Suggested for SQL Server with Sage 100 Premium? - in our content library. We are going to be updating/consolidating this information within the next few months at one of our 90 Minds Power Hours. I has most of the FAQ that I've encountered around Sage 100 Premium. 



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 4.  RE: SQL: Sage Runtime CAL vs Full SQL license - Any Change In What You Recommend?

    Posted 08-26-2025 15:44

    That's a great document!  Thanks @Wayne Schulz



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------