• New Sage Payroll Update v27.1 Released
    Includes ERR and CWPS enhancements
  • New Sage Payroll Update v27.1 Released

KB Category: Sage Drive

Sage Drive Issue – ‘Your computer is not connected to the Internet’

Sage Drive requires a broadband Internet connection with a download speed of at least 4Mbps, and an upload speed of at least 2Mbps. You can check your connection speed at various sites online, such as www.speedtest.net

When opening or working in a company that’s shared using Sage Drive, the following message may appear:

”No Internet connection”
”your computer is not connected to the Internet”

To check to see if the connection has been restored, and to submit your changes, click Retry.
If the connection cannot be restored, and you need to continue processing data, click Work offline.

WARNING: If you choose to work offline, you must advise anyone connected to your data using Sage Drive to stop processing, otherwise they will lose their work when you go back online.
To discard your changes and close Sage Accounts, click Close.’

This message appears on the Sage Drive main site if the connection to the Sage Drive service is lost, for example, if the main site has Internet issues, or if you need to update to a Sage Drive compatible version of your software.

Using Sage 50 Accounts v23.2 or above

If you receive this message, you have the option to Retry, Work offline or Close.

Retry

If you choose to Retry:

  • If it reconnects successfully – the entry you’re posting posts successfully and it’s OK to continue posting at all sites.
  • If the reconnection fails – the same No Internet Connection message appears again.

 

Work offline

If you choose to Work offline, all remote sites should stop posting until the main site reconnects.

Warning

Pimbrook software strongly recommend not selecting to working offline. Any time it’s offline we suggest that everyone should stop working as this may result to loss of data.

 

If users continue to work in this company at the remote sites, any postings they make from this point will be lost when the main site reconnects.

When the main site reconnects to Sage Drive, users working at remote sites see the following message:

‘Sage Drive
The main site has reconnected to this Sage Drive Company.
Any changes you make now will not be overwritten by the main site.
To continue, click OK.’

Once this message appears, they must check and if necessary re-enter any postings they’ve lost.

 

Summary

  1. Keep clicking on the Retry button until it connects
  2. If you choose to work offline ; all the remote sites should stop posting until the main site reconnects

Sage Drive Issue – Prompt for Sage ID when opening Sage 50 Accounts

When you open Sage Accounts, you may be prompted for your Sage ID sign in details that were used when setting up Sage Drive.

Why do I get this prompt?

‘For security reasons you must occasionally re-enter the Sage ID login details for Sage Drive’ when opening Sage 50 Accounts

When you open a Sage Drive company and enter your Sage ID login details, a token is created on your computer that lasts for 6 months. This means you shouldn’t have to enter your login details again within this period, unless something changes on your computer.

Previously, when using Sage Accounts, on the day your token expired, you had to enter your Sage ID login details to access your software.

In Sage Accounts 25.1 and above, from 30 days before the token expires, a warning message appears letting you know that your token will expire with the option to enter it immediately, or to be reminded later.

30 days – 1 day warning message

Sage ID expiry

for security reasons you must occasionally re-enter the Sage ID login details for Sage Drive.

The current details for user “***user email address***” will expire in xx days. To continue to access this company, please re-enter the Sage ID and password.

If you’re ready to log in, click Log in now. If not, click Remind me and select a time that suits you then click Log in later.

If you know your Sage ID login details, click Log in now and enter the details and click Sign In.

If you don’t have the Sage ID login details, click the Remind me drop-down and click the time when you want to be reminded, then click Log in later. Your software will then open as usual.

24 hour warning message

When you’re within 24 hours before the token expires, the following message appears:

Sage ID expiry

for security reasons you must occasionally re-enter the Sage ID login details for Sage Drive.

The current details for user “***user email address***” will expire in 24 hours. To continue to access this company, please re-enter the Sage ID and password.

If you know your Sage ID login details, click Log in now and enter the details and click Sign In.

You can still click Close and access you software at this stage, but once past the 24 hour period, you must enter your Sage ID login details to gain access. 

Ensure you enter your correct details

If you’re still prompted to login, please enter the Sage ID email address and password.

At the main site This is the email and password you used when uploading your data to Sage Drive.
At a remote site Please enter the Sage ID email address and password for the user at the remote site. If different to the main site

 

Summary:

The correct Sage ID and password must be entered to open Sage

Sage Drive Issue – ‘The main site is no longer communicating with this Sage Drive Company….’ on a remote site

When opening or working in a company that’s shared using Sage Drive, the following message may appear:

‘Sage Drive
The main site is no longer communicating with this Sage Drive Company; this may mean that it has encountered an error and has chosen to work offline…’

This appears on remote sites if the main computer for the Sage Drive Company isn’t currently online. For example, the computer may be switched off, or the user has chosen to work offline.

If you receive this message, we recommend that you close Sage Accounts and contact the user at the main site to check what is happening.

If main site is switched off

If the main site has logged out of Sage 50 Accounts and turned off their computer, you’re fine to work in Sage 50 Accounts at your remote site. When the main site reconnects, any changes you’ve made are synced to the main site.

To carry on posting, select the box  I understand that if I continue using Sage Accounts… check box and click OK.

If main site is switched on

If the main site computer is switched on, but no-one is logged into Sage 50 Accounts on that computer, you’re fine to work in Sage 50 Accounts at your remote site. When the main site reconnects, any changes you’ve made are synced to the main site.

You can try to refresh Sage Drive by following these steps:

  1. Click Tools, then click Sage Drive.
  2. Click Lock Sage Drive, then click Refresh Sage Drive.

To carry on posting, select the box  I understand that if I continue using Sage Accounts… check box and click OK.

If main site is switched on but offline

If the main site computer is switched on, and the user has chosen to work offline, we recommend that you stop processing at your remote site until they reconnect.

To check if they are working offline, the main site user can check if Sage Drive: Offline appears on the status bar at the bottom of Sage 50 Accounts.

Warning:

Pimbrook software strongly recommend not selecting to working offline. Any time it’s offline we suggest that everyone should stop working as this may result to loss of data.

If you continue, any changes you make from this point will be lost when the main site reconnects.

When the main site reconnects to Sage Drive, the following message appears at your remote site:

‘Sage Drive
The main site has reconnected to this Sage Drive Company.
Any changes you make now will not be overwritten by the main site.
To continue, click OK.’

Once this message appears, you should check and if necessary re-enter any postings you’ve lost.

Summary

In most cases – To carry on posting, select that  I understand that if I continue using Sage Accounts… check box and click OK.

If the main site computer is switched on, and the user has chosen to work offline, we recommend that you stop processing at your remote site until they reconnect.

Pimbrook software strongly recommend working offline. Any time it’s offline we suggest that everyone should stop working as this may result to loss of data.

Sage Drive Management Centre – Control who can access your company data

When you share your Sage 50 Accounts data in Sage Drive, you have complete control over who can access it and how. You can easily add and manage users within the Sage Drive Management Centre. (https://drive.sage.com/mc)

  1. Log in to Sage Accounts using the Manager Logon name, and related password if you’ve set one up.
  2. If the new user doesn’t already have their own Sage Accounts user name, create one now.
  3. On the menu bar, click File then click Manage Sage Drive.
  4. Enter your Sage ID email address and password then click Sign In.
  5. Click Add User  then enter the new user’s name and Sage ID email address.
  6. From the Access level drop-down, choose the access level for the new user:
Owner

 

 

Gives access to manage users in the Sage Drive Management Centre.

No remote access to your Sage Accounts data.

Owner and User Gives access to manage users in the Sage Drive Management Centre.

Gives remote access to your Sage Accounts data.

User Gives no access to manage users in the Sage Drive Management Centre.

Gives remote access to your Sage Accounts data.

Accountant To allow your accountant to remotely access your data, choose this option.

7.If you selected Owner, proceed to step 8. Otherwise select how the user can connect to your data:

User Allows the user to access the data from an installation of Sage 50 Accounts.
Mobile Sales Allows the user to access the data using the Sage 50 Accounts Mobile Sales app.
Tracker Allows the user to access the data using the Sage 50 Accounts Tracker app.
Accountant Allows your accountant to access the data using the Sage 50 Accounts Client Manager.

 

8. To save the settings, click Save.

9. Advise the new user what the encryption password is for your data. This is the password you used when you originally uploaded the data.

The new user receives an advising them how to connect to your company data. For the new user to connect to your data, they must install the same version of Sage Accounts that you have, or download the relevant business app. For your accountant to connect to your data, their Sage 50 Accounts Client Manager must be the same version as your Sage Accounts

To amend or remove a user’s access to your data, in the Management Centre on the right-hand side click By user, click the user name then click Edit user  or Delete user  as required.

Need more users? Upgrade to Sage 50cloud for 25 connected users or purchase additional users for your existing software

Sage Drive Issue – Waiting to Open Queue.dta

When using Sage Drive, when you open the software at either the main site or a secondary site, the following messages may appear:

  • ‘Waiting to open Queue.dta’
  • ‘Queue.dta is in use. Please wait until this file is available’
  • ‘The Sage ID user <<Sage ID email address>> on computer <<computer ID>> is currently processing at <<the main / a remote>> site.

 

To resolve this issue please click the appropriate options below:

Do you use Sage Drive? If Yes

Are all of your computers with a Sage installation running the latest build of your software version

If possible, restart the computer where your data is held.

If this isn’t possible, you must instead reset the Sage services and processes.

Reset the Sage services and processes

You must follow these steps on the computer or server where your Sage Accounts data is held. If using Sage Drive, you should carry these steps out at both the Sage Drive main site and remote site.

If you’re using a networked version of Sage Accounts, all other users must be logged out of the data.

  1. Close Sage Accounts.
  2. Hold down Ctrl + Shift + Esc to open the Windows Task Manager.
  3. Click the Processes
  4. Right-click the relevant process and click End Process then click End process.
Version Windows 7 and below Windows 8 and above
25 sg50svc_v25.exe *32

sg50CtrlSvc_v25.exe *32

Sage 50 Accounts Service v25

Sage 50 Accounts Control Service v25

24 sg50svc_v24.exe *32

sg50CtrlSvc_v22.exe *34

Sage 50 Accounts Service v24

Sage 50 Accounts Control Service v24

23 sg50svc_v23.exe *32

sg50CtrlSvc_v23.exe *32

Sage 50 Accounts Service v23

Sage 50 Accounts Control Service v23

22 sg50svc_v22.exe *32

sg50CtrlSvc_v22.exe *32

Sage 50 Accounts Service v22

Sage 50 Accounts Control Service v22

21 sg50svc.exe *32

sg50CtrlSvc.exe *32

 

Sage 50 Accounts Service

Sage 50 Accounts Control Service

 

5.In Task Manager click the Services

6.Right-click the relevant services and click Start Service.

v25 §  Sage 50 Accounts Service v25

§  Sage 50 Accounts Control Service v25

v24 §  Sage 50 Accounts Service v24

§  Sage 50 Accounts Control Service v24

v23 §  Sage 50 Accounts Service v23

§  Sage 50 Accounts Control Service v23

v22 §  Sage 50 Accounts Service v22

§  Sage 50 Accounts Control Service v22

v21 §  Sage 50 Accounts Service

§  Sage 50 Accounts Control Service

7.Close Task Manager window.

Stop the backup manager processes

  1. Hold down Ctrl + Shift + Esc to open the Windows Task Manager then click the Processes
  2. If listed, right-click the following processes and click Stop.
    • Sage 50 Check Data Standalone App – CheckDataStandaloneApp.exe *32
    • Sage 50 Backup Standalone App – BackupStandaloneApp.exe *32
    • Sage 50 Restore Standalone App – RestoreStandaloneApp.exe *32

These services will restart automatically when your next scheduled backup runs.

Delete the queue.dta if present in the data path  

Summary

If using Sage Drive, you should carry these steps out at both the Sage Drive main site and remote site.

  1. Stop the sage data service
  2. Check and stop any of the 3 backup manager process (i.e checkDataStandaloneApp, BackupStanaloneApp and RestoreDataStandaloneApp)
  3. Delete the queue.data in the data path on the server/Mainsite

Sage Drive Issue – ‘The Sage Drive Company you have selected is from version xx of Sage Accounts…’

When connecting to a Sage Drive company from Sage 50 Accounts on a remote site, the following message may appear:

‘The Sage Drive Company you have selected is from version [22/23/24/25] of Sage Accounts.
Please select a company in the list which is from version [25/26] of Sage Accounts.’

This occurs if you’re using Sage 50 Accounts v25 or above, but you try to connect to company data from an earlier version. To connect to data using Sage Drive, you must use the same Sage 50 Accounts version as the main site.

Before you can open the company, you must either:

  • Upgrade Sage 50 Accounts at the Sage Drive main site so it’s the same versions as the remote site:

Upgrade Sage 50 Accounts to v25 >
Upgrade Sage 50 Accounts to v26 >

  • Alternatively, install the correct lower version of Sage 50 Accounts on your computer.

Summary:

Everyone must be on same version

Sage Drive Overview

How Sage Drive for Sage 50 Accounts works

With Sage Drive you and your colleagues can access your live Sage Accounts data from remote locations using the Internet. You get the great features and reliability of your desktop software, plus the flexibility of sharing your data through the cloud.

Sage Drive is not a data backup service and should not be used as a replacement for your local computer network, you should still take regular backups of your data.

For Sage Drive to work smoothly a stable internet connection is required. Please make sure your internet connection at all sites meet the following recommended requirements:

  • Recommended download speed: 4Mbps or higher
  • Recommended upload speed: 2Mbps or higher

You can check the speed of your internet connection at various sites online, such as www.speedtest.net

Steps

1. Upload your data

The first step is to upload an encrypted copy of your Sage Accounts data to the Sage Drive cloud service.

This doesn’t move your existing Sage Accounts data. It’s still held on your computer or network, but any future changes you make to your data are also uploaded to the secure copy in the cloud.

2. Invite others to access your data

This is optional. If you have colleagues or an accountant that you want to allow to access your live data, you can invite them through the Sage Drive Management Centre.

3. Connect to your data from another location

You and any invited colleagues can now connect to your data via the Internet on any computer that has the same version of Sage Accounts installed. This gives you access to work on your data as though you were at your original data location.

4. Syncing data

As you and your colleagues work on your data, all changes are uploaded to the copy of your data in the cloud and then regularly downloaded to all other connected locations. This means you and your colleagues are always working on the latest version of your data.

Remove a company from Sage Drive – v21 only

Remove a company from Sage Drive – v21 only

On occasions, it may be necessary to remove your company from Sage Drive and start again. For example, if you forget the encryption password you set up, or you need to change the data owner. If you aren’t comfortable with deleting files you may wish to seek the assistance of your IT Support.

You must follow these steps on the computer at the main site where your data is held.

Check the data director
1. On the menu bar, click Help then click About.
2. Check the Data Directory.

 

Delete company from Sage Drive Management Centre
1. Close Sage Accounts and visit https://drive.sage.com/mc/signon
2. Log into the Sage Drive Management Centre using your Sage ID.
3. Select the By company view and click the company you want to delete.
4. Click the Delete company icon

This doesn’t delete the data on your server, just the copy of the data held in Sage Drive.

5. To delete other companies in the list, repeat steps 3 and 4.

If you’ve shared multiple companies using Sage Drive, you must remove all companies.

6. Sign out  then close the Internet browser.

 

Remove all Sage Drive data

These steps remove all Sage Drive data from your computer. If you’ve more than one company, and want to remove and reconnect single companies, please continue to the Remove Sage Drive for a single company section.

If you’re using a network version of Sage Accounts, all other users must log out of the data.

1. Press the Windows Key  + R on your keyboard.

2. Enter Services.msc and click OK.

3. Right-click the Sage 50 Accounts Service then click Properties.

4. Make a note of the Path to executable.

5. Right-click each of the following services and click Stop.

  • Sage 50 Accounts Control
  • Sage 50 Accounts Service
  • Sage 50 Accounts Remote Application – if you’ve installed Service Pack 5, this service no longer exists.

6. Press the Windows Key  +on your keyboard.

7. Browse to the folder that contains the Path to executable you noted in step 4.

For example, if the Path to executable was C:\Program Files\Sage\Accounts\sg50svc.exe browse to the folder C:\Program Files\Sage\Accounts

1. Right-click each of the following files, click Delete, then click Yes.

  • Sg50Svc.sqlite3
  • Sg50Svc.sqlite3-Shm
  • Sg50Svc.sqlite3-wal

If you can’t find these files, contact your IT support for further help.

1. Press the Windows Key  +on your keyboard.

2. Browse to the following location:

  • 32 bit – C:\Windows\System32\config\systemprofile\AppData\Local\Sage\SSB\Accounts\Collaborate
  • 64 bit – C:\Windows\Syswow64\config\systemprofile\AppData\Local\Sage\SSB\Accounts\Collaborate

3. Delete the contents of the Collaborate folder.

4. Press the Windows Key  + E on your keyboard.

5. Browse to the following location:

  • C:\ProgramData\Sage\Accounts\SageDrive

If ProgramData folder doesn’t show, you may need to Show hidden files and folders in Windows.

1. Delete the contents of the SageDrive folder.

2. Press the Windows Key  +on your keyboard.

3. Enter Services.msc and click OK.

4. Right-click each of the following services and click Start.

  • Sage 50 Accounts Control
  • Sage 50 Accounts Service
  • Sage 50 Accounts Remote Application – if you’ve installed Service Pack 5, this service no longer exists.

If required, you can now upload your data to Sage Drive again.

Remove Sage Drive for a single company

If you’re only having the problem with one company, you should delete the company from the Sage Drive Management Centre, then open Sage Accounts and select Disconnect.

Upload data to Sage Drive again, if required

 

 

  • 1
  • 2