Sage 100

 View Only
  • 1.  Sage Intelligence - Sage Premium Upgrade from 2020 to 2022

    Posted 01-26-2024 22:31

    I upgraded Sage Premium from 2020 to 2022.  Does anyone remember what needs to be done for Sage Intelligence to connect tot he new instance?  I'm pretty sure I have to check something in security in SQL Studio Management.  I know I have it documented, if I only I could find that.  The Sage Intelligence repository path is the same and it is on the same server.  Below is the message I get when I run a report.  The password for MAS_Reports is the same in the new SQL instance.  I have been able to update the Access databases.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------


  • 2.  RE: Sage Intelligence - Sage Premium Upgrade from 2020 to 2022

    Posted 01-27-2024 08:45

    If you haven't already done so, run the Sage 100 Premium SQL Settings Utility.



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



  • 3.  RE: Sage Intelligence - Sage Premium Upgrade from 2020 to 2022

    Posted 01-27-2024 11:19

    Thank you @Doug Higgs, that was the easy step I was missing.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------