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.
Why do Users Need Remote Data Access?
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.
- Users no longer need to be present in the workplace to access a network or file, and IT specialists no longer need to connect new systems to the business network.
- It enables employees to work from any location and allows IT staff to manage and monitor endpoints remotely.
Please Keep in Mind the Following for Remote Data Access
- High-speed internet access is required for optimal performance (with download speeds of at least 25mbps and upload speeds of at least 10mbps).
- The maximum file size for shared companies is 5.3GB.
How to Setup Remote Data Access in Sage 50 Accounts?
Follow the below all mentioned tips and steps to learn how to setup remote data access in Sage 50 accounts v27 and above.
Method I- Check if you can use a remote data access
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.
- 4Mbps download speed
- 2Mbps upload speed
Method II- Backup Sage data
- You have to click File and then you have to click Backup and then take a backup of your data.
- Go to the File menu then click Back up.
- After that click Browse then choose a safe location to save the file.
- Now click OK.
- Select all file types to include in the backup if you want to backup also reports, invoices, transactions, and layouts.
- Thereafter click Yes and then click Close.
- Finally, click OK if not done click here to get more steps to backup Sage 50 data.
Method III- Allow Remote Data Access
You need to use Remote Data Access you will need to link the company to your Sage account.
- You have to open Sage 50 Accounts and then log in as Manager.
- Then you have to click Settings and then you have to click User Management and then you have to click Users.
- Now you have to click Manager and then click on Edit.
- Can you choose the Allow Remote Data Access checkbox?
- Yes- Confirm the details and then you have to click Continue, that your company data is already linked to your Sage Account.
- No- If you are not able to select the checkbox, then you will need to link your company data to your Sage account, then you have to click Get started now with your Sage account and then you have to follow the instructions that are displayed on the screen.
- Then you have to click Continue.
- Now you have to enter your first and last name and then you have to click on Yes that I am the right person.
- After that, you have to confirm your company information and then you have to click Continue.
- Now you have to log in to your Sage account.
I have a Sage account- Enter your login details.
I don’t have a Sage account- You have to click on Create account and then you have to follow the steps to create one.
- Then after linking your company data, you have to select the Allow Remote Data Access check-box and then you have to click Continue.
Method IV- Create a Passphrase
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 will need to enter and then confirm the passphrase, and then you have to save it in a secure location and then you have to click Save.
You can now access your data by Remote Data Access.
May be useful- Sage 50 Error Could Not SYNC the Remote Data Access CompanyHow to Invite Users to a Shared Remote Data Access Company
- Ensure all other users are logged out of the company.
- Open the company navigate to Maintain Users, and Set Up User Security.
- If the company is currently shared, select “Yes” when prompted to Pause sharing.
- Choose “New User.”
- For existing users, select “Edit User’s Rights (or Roles).”
- If a user appears on the list with an asterisk, select “Add user to this company.”
- Fill in the User’s name, Password, and Email.
- Select the user’s level of access and save the record. Repeat these steps to add any additional users.
- Once finished, click “Save and close.”
- A shared company will automatically resume sharing and send invitations to the users.
- Users will receive an invitation email to join the shared company and will be prompted to create a Sage account if they don’t already have one.
How to Successfully Share Companies and Manage Users with Remote Data Access
To set up Remote Data Access Multi-User with Sage 50, ensure you have the following:
- An up-to-date Sage 50 version on your computer.
- Acquire a Sage Drive multi-user license, separate from the Sage 50 multi-user license.
- Each user accessing the company via Sage 50 must have a unique Sage account email address, including local users on the local network.
- A reliable high-speed internet connection:
- For optimal performance: Download speed of at least 25mbps and an upload speed of at least 10mbps.
- Minimum requirement: Download speed of 25mbps and an upload speed of 10mbps.
- Companies with databases: Under 500 megabytes (not using inventory or multiple lines on transactions) can often work well with an upload speed of 10mbps.
- For Larger Companies: For companies larger than 500 megabytes (not using inventory or multiple lines on transactions), an upload speed of 10mbps or more is recommended for the best performance.
- Companies using inventory and/or multiple lines on transactions should aim for an upload speed of at least 10mbps for optimal performance.
- Keep in mind the data size limit for Remote Data Access companies is 5.3GB, which includes attachments and archives.
- If your database exceeds 5.3GB, utilize the purge process to reduce its size.
- If you have an existing Sage 50 Accounting Multi-user local network setup, you must convert it to a standalone version of Sage 50 Accounting.
How to Rebase a Remote Data Access Company
Always back up Sage 50 data before proceeding with advanced solutions.
- Go to the Help menu, then select Support Utilities, and choose “Rebase Remote Data Access Company” (for 2020 and earlier versions, use “Rebase Sage Drive Company“).
- Click “Close” when you see the message confirming successful upload to Remote Data Access.
- Verify that the company opens without any errors on the other computer(s).
Troubleshooting Remote Data Access Issues and Error
Sorry if you are having issues with Remote Data Access. Check the following if you have specific issues.
- Service status- If you want to check the current Remote Data Access service status, then you have to visit status.sage.com
- Is Remote Data Access enabled- You have to double check in case Remote Data Access is enabled in your company.
- Check your Internet speed- All of the sites need a minimum of 4 MBPS to download speed and the upload speed should be 2Mbps. Also, it is advised against using a wireless Internet connection. The Network Speed Test is accessible from the Start menu in Windows 10. Alternatively, you might use a website like www.speedtest.net to check online.
- Check your volume of data- When working remotely large sets of data can cause performance 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.
After attempting to reconnect remote data access remains in an offline state at the main site
To solve this issue follow the below steps.
- You will need to disconnect and reconnect your data from Remote Data Access.
Sage Error Waiting to Open Queue.dta when using Remote Data Access
- Recommend a download speed of 4Mbps or higher
- Recommended the upload speed of 2Mbps or higher.
Error Processing, please wait when using Remote Data Access Sage 50
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,
- You have to open your software and then you have tp choose to open Demonstration data and then you have to click Ok.
- Then you have to log on as MANAGER with no password and then you have to click OK.
- Now you have to click Help and then you have to click About and then you have to check your software version number.
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
- Make sure that all users are logged out of Sage 50cloud Accounts at your current site.
- On your keyboard, you have to press the Windows key+ R, and then you have to enter Services.msc then you have to click OK.
- You have to right-click the service for each of the following services for your software version and then you have to click Stop.
- Sage 50 Accounts Service vXX
- Sage 50 Accounts Control vXX
- Then you have to restart the services, then you have to right-click the relevant service and then you have to click Start.
- You just have to open your software and then check whether you can log in as normal.
Sage 50 Remote Data Access Sign-in Error the Sage ID you’ve entered has had its access revoked
Refresh your access at another site
- To enable Remote Data Access, sign in as a manager to Sage 50cloud Accounts from another location.
- After selecting Settings, you have to go to User Management, and then select Users.
- Select Edit after selecting the user name that is receiving the problem.
- Clear the Allow Remote Data Access check box by clicking Remote Data Access, then click Yes.
- After clicking Save, you have to click Finish.
- Click Edit after selecting the same user name once more.
- Choose the Allow Remote Data Access check box after clicking Remote Data Access.
- Enter the user’s information, then click Complete, Save, and Close.
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
- Press Windows Key + R on the machine holding your data at the location where this problem is occurring, type Services.msc, and then click OK.
- Right-click the service and select Stop for each of the following services for your software version. See the Stop and Restart Sage Data Service and Control Service guide if you need more help.
- Sage 50 Accounts Service vXX
- Sage 50 Accounts Control vXX
- Clear everything in the next folder:
- 32 bit: C: Windows System32 Configuration SystemProfile AppData Local Sage SSB Accounts
- 64 bit: C:\Windows\Syswow64\config\systemprofile\AppData\Local\Sage\SSB\Accounts\ Collaborate
- Then you have to re-start the services you stopped in step 1.
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:
- You have to completely remove the Remote Data Access from your company
- Then you have to set up Remote Data Access again. Which will include granting access to remote users
- Now you have to reconnect remote users.
Remote Data Access Service is Currently Unavailable Sage 50
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.
- You have to open your software and then select open Demonstration Data and then you have to click OK.
- Now you have to log in as MANAGER with no password and then you have to click OK.
- After that, you have to click Help and then you have to click About and check your number of software version
Clear the Collaborate and ConnectedBridge folder contents
- You have to close Sage 50cloud Accounts and then you have to stop the following services.
| 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 |
- Then you have to hold down the Window key + E and then you have to browse to the following location.
| 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 |
- Use Ctrl + A on your keyboard to select all of the contents of the Collaborate folder, and then press Delete to remove them.
- In the location where XXX is the active Windows user, navigate to:
C:\Users\XXX\AppData\Local\Sage\SSB\Accounts\ConnectedBridge
- Use Ctrl + A on your keyboard to select all of the contents of the ConnectedBridge folder, and then press Delete to remove them.
- Start the following services:
| 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
- You have to visit my.sage.co.uk and then you have to click Sign in.
- Then you have to enter your email address and then you have to click Continue.
- Now you have to click Forgot your password? Then you have to enter your Email.
- After completing the CAPTCHA you have to click Continue.
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:
- https://signon2.sso.services.sage.com
Also check to see whether your firewall, antivirus program, or proxy server has restricted access to the following Sage services.
- sg50svc vXX.exe.
- Sage.UK.Accounts50.Data.Service.Control vXX.exe.
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
- On your keyboard, you have to press the Windows Key+R and then you have to enter Services.msc and then you have to press Enter.
- Then you have to Browse to
- v28 – C:\Program Files (x86)\Sage\AccountsServiceV28
- v27 – C:\Program Files (x86)\Sage\AccountsServiceV27
- Now you have to right-click the following relevant files and then click Run as administrator and if asked you have to click Yes.
- v28 – sg50svc_v28.exe or sg50svc_v28
- v27 – sg50svc_v27.exe or sg50svc_v27
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.
- Now you have to open Sage 50cloud Accounts and then you have to try the process that has caused an error in the first place.
- In case the error no longer persists, if identified the issue then you can follow the below steps to correct the issue permanently.
Correct the issue permanently
- You have to close the command prompt window.
- Then on the keyboard, you have to press the Windows Key+R and then you have to enter Services.msc and then you have to click Enter.
- Now you have to check the Data Service is still not running.
- You have to right-click Sage 50 Accounts Service vxx and then you have to click Properties.
- Then you have to click the Log On tab and then you have to click This Account.
- Now you have to enter the details for your admin and password.
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.
- After that, you have to click OK and then you have to right click Sage 50 Accounts Service vxx, and then click on Start.
Check your regional settings are set to UK
- You have to hold down the Windows key+R and then you have to type intl.cpl and then you have to click OK.
- Then you have to go to the Formats tab on the drop-down menu and then you have to select English (United Kingdom).
- Windows 8 and above- You have to hold down the Windows key+R and then you have to type ms-settings:regionallanguage and then you have to click OK. You have to click Region and then make sure the Regional and Regional format is set to the United Kingdom.
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.
- Lastly, you have to restart your computer.
Disable IPV6
- First, you have to open the Windows Control Panel.
- Then you have to click Network and Internet and then click Network and Sharing Center.
- After that, you have to click Change adapter settings.
- Then you have to right-click your connection and then choose Properties.
- Lastly, you have to clear the Internet Protocol Version 6 (TCP/IPv6) check-box.
Sage 50 Remote Data Access an Error has been Encountered with Sage Account
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
- Stop the following services.
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 |
- You have to clear the content of the following folders:
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
- You have to restart the services that you have stopped in Step 1.
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:
- In your Windows taskbar, you have to right-click the time and date and then you have to click Adjust date/time
Check your regional settings
Check the regional settings that they are set correctly:
- You have to hold down the Window key and then press R.
- You have to enter intl.cpl and then you have to click OK.
Frequently Asked Questions
When using Sage 50cloud Accounts v28 or above which site is the main or remote site?
Remote Data Access had a main site, where the data has been uploaded, and the remote sites which have acquired the data, in version v27 and below. By removing the concept of main and remote sites all sites are now treated the same.
What are the system requirements for Remote Data Access?
Your Internet connection requires a download speed of 4 MBPS and an upload speed of 2 MBPS.
What is Sage 50 Remote Data Access?
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.
What internet speed is recommended for optimal performance with Remote Data Access?
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.
Is there a limit to the data size for Remote Data Access companies?
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.
How do I invite users to join a shared Remote Data Access company?
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.
What should I do if I need to rebase a Remote Data Access company?
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.
