Solution Properties
Solution ID:
225924550092449
Last Modified Date:
Wed Mar 22 20:20:00 UTC 2023
Taxonomy Path:
Category//Setup and configuration
Author:
LegacyAuthorUS
Error: “Sage 50 could not upload your company to Microsoft 365”
Description
Cause
  • The anti-virus or firewall is blocking the connection
  • An environment issue is blocking the connection
  • Sage does not have enough permissions to your working directory
  • The group did not get created properly on Microsoft 365
  • Your version of Microsoft 365 is not compatible with the Sage 50cloud integration – To check if your version is compatible, see Related resources
Resolution
[BCB:1:Backup warning:ECB]
[BCB:3:Network warning:ECB]
[BCB:4:Operating system warning:ECB]


Option 1: Click Upload again

  1. Try to click on upload again 2 or 3 times.
  2. If you have the same error go to Option 2.

Option 2: Replace the Tokencache and Exchange.sqlite files

  1. Close and backup all Sage 50 file currently open.
  2. Go to: C:\Users\[your user]\AppData\Roaming\Sage\AAD and delete the file with the extension “.tokencache” in this directory.
  3. Go to: C:\ProgramData\Sage\Sage Data Exchange and delete the file “SageDataExchange.sqlite"
  4. Launch Sage 50.
  5. Upload your company file to Microsoft 365 (note: you will be prompted to log in to your Office account).
  6. If the upload is Not successful, go to Option 3
  7. The issue is resolved if the upload is successful.

Option 3: Test the Sample company

  1. Open the Sample company from the welcome page or through C: C:\Users\Public\Documents\Simply Accounting\[your edition]\Samdata\[your version of Sage 50] – Universl.sai
  2. Upload the sample company to Microsoft 365 using your user account.
  3. If the Sample Company upload, go to Option 4.
  4. If the Sample Company returns the same error, you most likely have an environment-related issue. You need to verify for another program or security feature that could interfere with the connection to Microsoft 365. (for example: firewall on your router). Contact your IT for more assistance.

Option 4: Run as administrator

  1. Right-click your Sage 50 icon on the desktop.
  2. Select: “Run as administrator”.
  3. Upload your company file.
  4. If Not successful, go to Option 5.
  5. If successful, modify the Windows permissions on your working directory. Contact your IT for more assistance.

Option 5: Add Sage “ODriveSync.exe” to your firewall exception

Windows Firewall:

  1. Go to Control Panel/Windows Firewall.
  2. On the left menu click: Allow a program or feature Through Windows Firewall.
  3. On the top right-hand corner, click: Change Settings.
  4. Below the list, click: Allow another program.
  5. Browse to C:\Program files (x86)\Sage 50 [your version]
  6. Add the app: Sage_SA_OdriveSync.exe
  7. Make sure you check the boxes for “Domain” and “Home/work”.
  8. Click ok to save your changes.
  9. Try to create a cloud backup.
  10. If Not successful, go to Option 3.
  11. If successful, your issue is resolved.

3rd Party Firewall Program:

  1. Contact your firewall program provider for assistance to add the exception for the app: C:\Program files (x86)\Sage 50 [your version]\ Sage_SA_OdriveSync.exe
  2. Try to create a cloud backup.
  3. If Not successful, go to Option 6.
  4. If successful, your issue is resolved.

Option 6: Disable Firewall and anti-virus

Default Windows Security Program:

  1. Turn Off Windows Firewall:
    • Go to Control Panel / Windows Firewall
    • On the left menu click: Turn Windows Firewall On or Off
    • Turn Off all firewalls
  2. Turn Off Windows Defenders Real-Time Protection:
    • Windows 10:
      • Go to the “Start” button
      • Open “Settings” (Using the Icon)
      • Go to: Update and security
      • On the left menu, click: Windows Defender
      • Turn Off Real-Time Protection
    • Windows 7:
  • Go to Control Panel/Windows Defender
  • Go to the Settings tab
  • On the left menu, click: Real-Time Protection
  • Turn Off Real-Time Protection
  1. Try to create a cloud backup.
  2. If Not successful, go to Option 7.
  3. If successful, consult your IT for assistance or check related resources to set the proper configuration. (Don’t forget to turn your security program back ON).

3rd Party Security Program:

  1. Contact your program provider for assistance to disable your Security program.
  2. Try to create a cloud backup.
  3. If Not successful, go to Option 7.
  4. If successful, consult your Security Program Provider or IT for assistance to set the proper configuration. (Don’t forget to turn your security program back ON).

Option 7: Delete the group on Microsoft 365

  1. Log in to the Microsoft 365 Admin Center: https://aka.ms/admincenter
  2. On the left menu, go to Groups/Groups.
  3. Select the “Sage – [your company name]” group.
  4. Click Delete Group.
  5. Repeat steps 1 to 3 of Option 5.
  6. Wait a minimum of 48h for the Group to get deleted from SharePoint.
  7. Upload your company file to Microsoft 365.
  8. If the upload is Not successful, contact Sage Support at 1-888-522-2722.
  9. If the upload is successful, your issue is resolved.

Option 8: I would rather not use M365

  1. Disconnect M365 from Sage 50 - see How to disconnect from Microsoft 365 integration

Which processes and ports do I need to allow through my firewall to ensure that Sage 50-Canadian Edition will operate correctly?
How can I tell what version of Microsoft 365 that I am using?
How to sync Sage 50 CA with Microsoft 365

[BCB:159:Chat 50 CA English:ECB]


Steps to duplicate
Related Solutions