Sage 100

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]
------------------------------

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
------------------------------

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

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

Original Message:
Sent: 01-27-2024 08:44
From: Doug Higgs
Subject: Sage Intelligence - Sage Premium Upgrade from 2020 to 2022

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
------------------------------