Set up Microsoft 365 for connected apps, the Web Portal, Self Service web app, Power BI, Power Automate, or the API

You can connect Sage 200 and Microsoft 365 to use:

  • Sage 200 Web Portal.

  • Sage 200 API.

  • Sage 200 Self Service web app.

  • Microsoft Power BI.

  • Microsoft Power Automate (formerly called Microsoft Flow).

How to connect Sage 200 and Microsoft 365

Follow the steps below to set up Microsoft 365:

  • Activate your Microsoft 365 subscription.

  • Create user accounts in Sage Business Centre and give them access to connected apps.

  • Connect Sage 200 to your Microsoft 365 account.

  • Set up user email addresses in Sage 200.

Note - information

You only need to activate and connect Sage 200 to your Microsoft 365 account the first time you start to use connected apps. Once you've set this up, you can use the Sage Business Centre to create new users, or give users access to new apps.

Note - information

The Sage Contact app for Sage 200 has now been withdrawn.

Activate your Microsoft 365 account

First activate your Microsoft 365 account so that you can use Sage applications with Microsoft 365.

You will need to have an existing Microsoft 365 Business Standard (formerly Office 365 Business Premium) or Enterprise subscription, to integrate with Sage 200. You can't move this from your existing provider to Sage, but you can still integrate it with Sage 200.

Note - information
  • Sage 200 can only be integrated with a Microsoft 365 Business Standard (formerly Office 365 Business Premium), Enterprise (E1, E3 or E5), or Office 365 Education (A1, A3, A5) subscription.

    For details of compatible Microsoft 365 subscriptions, see Sage 200 – Which version of Microsoft 365 is compatible for use with the Sage 200 API and how to check before onboarding (opens in a new tab).

  • Your Microsoft 365 subscription must include Microsoft Entra ID P1 or P2 (formerly Azure Active Directory Premium P1 or P2).

  • The user agreement gives your Sage 200 software access to your Microsoft 365 subscription. It does not affect your Microsoft 365 subscription or any existing support contracts you may have. These remain with your existing provider.

  1. You must first contact Business Partner Services at [email protected] (opens in a new tab) to register your Microsoft 365 subscription.

    You will receive a form to complete the registration of your Microsoft 365 subscription. Once you have returned the form, it can take up to 48 hours to activate your subscription.

  2. When you register to use Microsoft 365 with Sage 200, you will receive an email to get started.

    Note: We recommend that you sign out of any Microsoft 365 software in your browser before you access the Sage Business Centre.

    • Select the link in the email to sign in to Sage Business Centre.

    • Sign in using your Microsoft 365 administrator email address and password. This is usually in the format admin@***.onmicrosoft.com.

      Note - information

      The user must have the administrator role Admin center access in Microsoft 365 whilst you activate your account and set up connected apps and the API. Once you have completed the full setup process, if you no longer want this user to have administrator access, you can change their role to User (no admin center access) in Microsoft 365 admin center.

      To view or change a user's role in the Microsoft 365 admin center, go to Users > Active Users, select the user, then select Manage roles. Note that you will not be allowed to change your own user role, so you must sign in using a different user account.

  3. You will be asked by Microsoft to accept permissions for the Sage Business Centre application. Select Accept to continue.

  4. You will be asked by Sage to accept permissions for apps to access your data. Select Accept to continue.

  5. Once you've activated your account, you can access the Sage Business Centre at https://ceo365portal.na.sage.com (opens in a new tab).

    Here you can create user accounts for people that will use Sage 200 apps.

    Sage Business Centre home page

Create user accounts

Once you've activated your account, create user accounts for each person that will use Microsoft 365 with Sage 200 apps.

You can create user accounts in the Sage Business Centre and the Microsoft 365 Admin Center.

  1. Sign in to the Sage Business Centre (https://ceo365portal.na.sage.com (opens in a new tab)).

  2. Select the Manage Users tab.

    Manage Users page in the Sage Business Centre

  3. Select Add users in Microsoft 365.

    This will open the Microsoft 365 Admin Center.

  4. Add your users in the Microsoft 365 Admin Center.

    1. Select the Add a user link on the Home page, or go to Users > Active Users and select Add a user.

      Microsoft 365 admin center - Active Users page

    2. Enter the Basics user account details.

      Microsoft 365 admin center - Add a user basic details

      • Enter the user's name and display name.

      • Enter the Username that will be used for the user's email address. The person will use this email address to sign in.

        Tip: Remember this email address, as you will need it later when setting up Sage 200.

      • If you select Send password in email on completion, the user will receive an email with their username and a temporary password.

        Note: This will allow the user to sign in to Microsoft 365, but they will not be able to use Sage 200 apps yet until you finish setting things up.

    3. Enter the Product licenses details.

      Microsoft 365 admin center - Add a user product licenses details

      • Select the product licence for Azure Active Directory Premium P1.

      • Select the product licence for Microsoft 365 Business Standard.

    4. Enter any of the Optional settings as required.

    5. When you've entered all the user's details, move to the Finish page and select Finish adding.

      Microsoft 365 admin center will confirm when the user is active.

  5. Give the user access to the all apps they will use, such as Power BI.

    1. Go back to the Sage Business Centre.

    2. Select the Manage Users tab.

    3. To set the user's access, select Edit next to the user.

    4. Tick the apps required, such as Power BI, then select Save.

  6. Repeat these steps for each person that will use a Microsoft 365 account with Sage 200 apps.

Note: You must also set up the user email addresses in Sage 200. To do this, see Set up user email addresses in Sage 200.

Tip: If you need to add multiple users in Microsoft 365, see this Microsoft support article: Add users individually or in bulk to Office 365 - Admin Help (opens in a new tab)

Connect Sage 200 to your Microsoft 365 account

After you activate your Microsoft 365 subscription, connect your Sage 200 site to your Microsoft 365 account.

To do this, install the Microsoft Entra private network connector (formerly Microsoft Azure Active Directory Proxy Connector) on your Sage 200 server. This connects your Sage 200 server to Microsoft Entra ID (formerly Azure Active Directory).

Note - settings

The Microsoft Entra private network connector requires Microsoft Windows 8.1, Windows Server 2012 R2, or later versions of Windows.

Note - information

The Sage Contact app for Sage 200 has now been withdrawn.

  1. Download the installer.

  2. On your Sage 200 server, run the installer application that you downloaded.

  3. Select Install and Configure.

  4. The Microsoft Entra private network connector setup will start.

    Note: This was previously called the Microsoft Azure Active Directory Proxy Connector for Sage 200 Professional versions up to 2023 R2.

    • Select Install.

  5. You will be asked to sign in to your Microsoft Azure account.

    • Sign in using your administrator user name and password.

      This is the same account that you used to sign in to the Sage Business Centre, and the Microsoft 365 account you used to activate your subscription and link to Sage 200.

      Note - information

      The user must have the administrator role Admin center access in Microsoft 365 whilst you activate your account and set up connected apps and the API. Once you have completed the full setup process, if you no longer want this user to have administrator access, you can change their role to User (no admin center access) in Microsoft 365 admin center.

      To view or change a user's role in the Microsoft 365 admin center, go to Users > Active Users, select the user, then select Manage roles. Note that you will not be allowed to change your own user role, so you must sign in using a different user account.

  6. Select Close when the setup is complete.

  7. You may be asked to sign in to your Microsoft Azure account again.

    Sign in using the same administrator user name and password as before, when you installed the Microsoft Entra private network connector.

  8. Open the Microsoft Entra admin center (formerly Azure Active Directory admin center) and sign in.

    entra.microsoft.com (opens in a new tab)

  9. Set up the applications that you want to use:

Note - information

If you need to set up the connection with a different administrator account, use Uninstall to remove the Microsoft Entra private network connector, then run Install and Configure again.

Note: You must also enter the Microsoft 365 email address for each user account in Sage 200. See Set up user email addresses in Sage 200.

Set up user email addresses in Sage 200

For each user, you need to enable Azure AD authentication and enter their Microsoft 365 email address.

  • This is required for users that will use Sage 200 connected apps, Power BI, Power Automate, or the API.

  • This is not required for users that will only use the Self Service web app.

Open: System Administration.

  1. Select the Users list.

  2. Right-click the user and select Properties.

  3. Select the API tab.

  4. Enable Azure AD and then enter the user's email address for their Microsoft 365 account.


Questions