Sage remote data access is used to share and access your company data remotely. Learn how to setup remote data access in Sage 50 accounts for Canadian Edition, or US Edition. Sage 50 Accounts has offered remote access in the form of Sage Drive for a while, but with the introduction of version 27, this was revitalized with Remote Data Access. For general use, a lot has stayed the same; however, there have been some changes to the process for uploading data and granting access to users.
Sage 50 remote data access is a feature that allows users of Sage 50 accounting software to access their accounting data from remote locations, providing flexibility and convenience for businesses.
With this tool, authorized users can work on their company’s financial data, manage accounts, and perform accounting tasks from virtually anywhere with an internet connection. This feature streamlines collaboration and enables efficient work, especially when team members are not present in the same physical location.
Follow the below all mentioned tips and steps to learn how to setup remote data access in Sage 50 accounts v27 and above.
If you want to use Remote Data Access, you will need to use an up-to-date version of Sage 50 Accounts and meet the needed minimum internet connection speed.
You need to use Remote Data Access; you will need to link the company to your Sage account.
You will need to enter this Passphrase, whoever will need to access the company data remotely. In length, it will be at least 15 characters, and it must contain at least one uppercase and one lowercase character. There is no maximum character length.
You can now access your data via Remote Data Access.
May be useful– Sage 50 Error Could Not SYNC the Remote Data Access Company
Note: To use RDA, you must have the same version of Sage 50 Accounts installed as the data owner and meet the required Internet connection speed.
Note: If you already have a Sage 50 account, you can easily log in; if you don’t have a Sage 50 account, you’ll need to click “Create Account” to sign up and create a new Sage 50 account.
Note: If a company doesn’t appear, check the uploaded data, and you’ll be invited to access it.
Verify the dataset ID by hovering over the details icon.
Note: If you don’t know the passphrase? The Manager user can find this from the Remote Data Access Settings.
To set up Remote Data Access Multi-User with Sage 50, ensure you have the following:
Always back up Sage 50 data before proceeding with advanced solutions.
Sorry if you are having issues with Remote Data Access. Check the following if you have specific issues.
If you experience any of the following when using Remote Data Access to access your data after having checked the items above, please click the appropriate link for instructions on how to fix the problem.
To solve this issue follow the below steps.
Version 29.0.286.0 of Sage 50 Accounts addresses this problem. Immediately install it if you haven’t already.
Before you start- Check your start- Check your version number
You must be using Sage 50 cloud Accounts v27 or above to use Remote Data Access.
To check your version,
In case you are using Sage 50cloud Accounts v27 or above, then follow the steps that are mentioned below.
Steps to Stop and Restart the Sage Data Service and Control Service
Refresh your access at another site
Now attempt to access the data on your website. Go to the following section if the problem still occurs.
Check your access and reconnect
Verify that Remote Data Access is still enabled in User Management by asking the MANAGER user.
Try disconnecting and then reconnecting with the business.
Provide the information if a separate Sage ID for a different user will be used to access the site. Ask the MANAGER to send you an invitation using a different email address if you want to connect it to your user record.
Try the following steps if this doesn’t fix the problem.
Clear contents of the Collaborate folder
To start a service Press Windows Key + R on your keyboard, you have to type services.msc, click OK, and then choose the necessary service from the context menu and click Start.
Remove Remote Data Access then reconnect users at the main site
In case the issue remains then you should:
Check Internet Speeds
All sites should have a minimum 4Mbps download speed and the upload speed should be 2Mbps for Remote Data Access to work.
Check your software version number
If you want to use Remote Data Access you must be using Sage 50cloud Accounts v27 or above.
To check your version.
Clear the Collaborate and ConnectedBridge folder contents
| Sage 50cloud Accounts v28 | Sage 50 Accounts Control v28Sage 50 Accounts Service v28 |
| Sage 50cloud Accounts v27 | Sage 50 Accounts Control v27Sage 50 Accounts Service v27 |
| 32-bit computer | C:\Windows\System32\config\systemprofile\AppData\Local\Sage\SSB\Accounts\Collaborate |
| 64-bit computer | C:\Windows\Syswow64\config\systemprofile\AppData\Local\Sage\SSB\Accounts\Collaborate |
C:\Users\XXX\AppData\Local\Sage\SSB\Accounts\ConnectedBridge
| Sage 50cloud Accounts v28 | Sage 50 Accounts Control v28Sage 50 Accounts Service v28 |
| Sage 50cloud Accounts v27 | Sage 50 Accounts Control v27Sage 50 Accounts Service v27 |
Change or reset your My Sage password
Check your firewall, antivirus, and proxy server settings
Please make sure that the computer hosting your Sage 50cloud Accounts data does not have the following URL blocked by a proxy server, firewall, or antivirus software:
Also check to see whether your firewall, antivirus program, or proxy server has restricted access to the following Sage services.
Check if you are using a mapped network drive
This problem can be fixed by switching to a UNC path if you are using a mapped network drive to connect to company data on a server or other device.
It is a mapped drive if the Data path starts with a letter other than C, like Z.
Change this to be connected using a UNC path if it is a mapped drive.
Try running the Data Service as an administrator
Test by running the data service directly
By doing this it will open a command prompt window that is related to the Data Service running as admin. You don’t have to close this window yet.
Correct the issue permanently
In case you are not sure, then you have to click Browse and then you have to click Advanced. You have to click Find Now and then you have to click Local Service and then you have to click OK and then you have to enter the Windows password.
Check your regional settings are set to UK
Windows 7 and below- You have to select the United Kingdom on the Location tab on the Current location drop-down menu and then you have to click OK.
Disable IPV6
If you have changed your Sage Account email address
In case you have changed the email address for your Sage Account login recently, then this can cause a problem when you next try to log in to Remote Data Access (RDA).
Clear content of Collaborate folder
If you want to stop a service then you have to press the Windows Key+R on your keyboard, then you have to enter Services.msc and then you have to click OK, then you have to right-click the required service and then you have to click Stop.
| Version | Services |
| v29 | Sage 50 Accounts Service v29Sage 50 Accounts Control Service v29 |
| v28 | Sage 50 Accounts Service v28Sage 50 Accounts Control Service v28 |
| v27 | Sage 50 Accounts Service v27Sage 50 Accounts Control Service v27 |
Located in
32 bit: C:\Windows\System32\config\systemprofile\AppData\Local\Sage\SSB\ Accounts\Collaborate
or
64 bit: C:\Windows\Syswow64\config\systemprofile\AppData\Local\Sage\SSB\ Accounts\Collaborate
Connected Bridge folder
Located in C:\Users\[UserName]\AppData\Local\Sage\SSB\Accounts\ConnectedBridge
If you again want to start a service then you have to press the Windows Key+R on your keyboard, then you have to enter the Services.msc and then you have to click OK, then right-click the required service, and then you have to click Start.
Check the time/date is set correctly
You have to check that the time and date are properly set:
Check your regional settings
Check the regional settings that they are set correctly:
Remote Data Access had a main site, where the data had been uploaded, and the remote sites that acquired the data, in version v27 and below. By removing the concept of main and remote sites, all sites are now treated the same.
Your Internet connection requires a download speed of 4 MBPS and an upload speed of 2 MBPS.
Sage 50 Remote Data Access is a feature that allows users to access their Sage 50 company data from anywhere with an internet connection. It’s a convenient way to work on your accounts remotely.
For best performance, it’s recommended to have a download speed of at least 25mbps and an upload speed of at least 10mbps. However, smaller companies that don’t use inventory or have multiple lines on transactions can work well with an upload speed of 10mbps.
Yes, the data size limit for Remote Data Access companies is 5.3GB, which includes attachments and archives. If your database exceeds this limit, you may need to use the purge process to reduce the database size.
First, ensure all other users log out of the company. Then, open the company, go to Maintain Users, Set Up User Security, and select “New User.” Fill in the user’s information and access level. Save the record, and the shared company will automatically send invitations to the users.
If you need to rebase a company, go to Help, Support Utilities, and select “Rebase Remote Data Access Company” (or “Rebase Sage Drive Company” for versions from 2020 or earlier). Follow the mentioned steps, and make sure the company opens without errors on other computers.
