Troubleshoot data service issues

Summary

How to resolve data connection issues when opening Sage 50 Accounts.

Description

One of the following messages can appear when you open the software:

Unable to connect to Sage Data Service on machine [computer name]
Data service unavailable messages

These messages appear if the service isn't running or if there's a problem connecting to the service from Sage 50 Accounts.

Install and run the data service on the computer that holds the data. This can be your local computer or a server.

NOTE: If you need help with any of these steps, refer to your local IT support.

Resolution

▼Restart the Sage Accounts data services on the machine where you hold your data

TIP:

Use our Data Service Manager that makes this process easier. To find out more, visit our using the Sage 50 Data Service Manager in v31 and above article.

Check if the services are installed

Access the computer that holds your data and press the windows key + R on your keyboard.
Enter services.msc, click OK and from the list of services, then check the relevant service:

Stop the Sage Accounts Data Service

Right-click the relevant service and click Stop.
- Sage Accounts v33 - Sage 50 Accounts Service v33
- Sage Accounts v32 - Sage 50 Accounts Service v32
- Sage Accounts v31 - Sage 50 Accounts Service v31
- Sage Accounts v30 - Sage 50 Accounts Service v30
- Sage Accounts v29 - Sage 50 Accounts Service v29
- Sage Accounts v28 - Sage 50 Accounts Service v28
- Sage Accounts v27 - Sage 50 Accounts Service v27
- Sage Accounts v26 - Sage 50 Accounts Service v26
Right-click the relevant control service and click Stop.
- Sage Accounts v33 - Sage 50 Accounts Control v33
- Sage Accounts v32 - Sage 50 Accounts Control v32
- Sage Accounts v31 - Sage 50 Accounts Control v31
- Sage Accounts v30 - Sage 50 Accounts Control v30
- Sage Accounts v29 - Sage 50 Accounts Control v29
- Sage Accounts v28 - Sage 50 Accounts Control v28
- Sage Accounts v27 - Sage 50 Accounts Control v27
- Sage Accounts v26 - Sage 50 Accounts Control v26

Services stuck on the Stopping status?

Start the Sage Accounts Data Service

Press the Windows Key + R on your keyboard then enter Services.msc and press Enter.
Right-click the relevant service and click Start.
- Sage Accounts v33 - Sage 50 Accounts Service v33
- Sage Accounts v32 - Sage 50 Accounts Service v32
- Sage Accounts v31 - Sage 50 Accounts Service v31
- Sage Accounts v30 - Sage 50 Accounts Service v30
- Sage Accounts v29 - Sage 50 Accounts Service v29
- Sage Accounts v28 - Sage 50 Accounts Service v28
- Sage Accounts v27 - Sage 50 Accounts Service v27
- Sage Accounts v26 - Sage 50 Accounts Service v26
Right-click the relevant control service and click Start.
- Sage Accounts v33 - Sage 50 Accounts Control v33
- Sage Accounts v32 - Sage 50 Accounts Control v32
- Sage Accounts v31 - Sage 50 Accounts Control v31
- Sage Accounts v30 - Sage 50 Accounts Control v30
- Sage Accounts v29 - Sage 50 Accounts Control v29
- Sage Accounts v28 - Sage 50 Accounts Control v28
- Sage Accounts v27 - Sage 50 Accounts Control v27
- Sage Accounts v26 - Sage 50 Accounts Control v26

NOTE: If the service is disabled, right-click it, select Properties, then choose Automatic in the Startup type dropdown, and press OK.

▼ If the service isn't showing

You need to install the service:

Download and install the relevant file:
- v32 and above - There’s no download for the Data Service only in v32.1 and above. Download the full software and choose to install Data Service only during the installation
- v31 (32-bit) Sage50Accounts_31_Dataservice_32bit.exe
- v31 (64-bit) Sage50Accounts_31_Dataservice_64bit.exe
- v30 (32-bit) Sage50Accounts_30_Dataservice_32bit.exe
- v30 (64-bit) Sage50Accounts_30_Dataservice_64bit.exe
- v29 - Sage50Accounts_29_Dataservice.exe
- v28 - SageAccountsDataService28.exe
- v27 - Sage50Accounts_27_Dataservice.exe
- v26 - Sage50Accounts_26_Dataservice.exe
To complete the installation, follow the on-screen prompts.
To install the latest updates for the data service, download and install the following relevant file:
- v28 and above- No update needed
- v27 - Sage 50 Accounts v27.1 update
- v26 - Sage 50 Accounts v26.3 update

▼ If the service is showing

To ensure the service is running correctly, stop and restart the service.

To do this, right-click on the relevant services for the version of Sage Accounts that you’re using:

Sage Accounts v33	Sage 50 Accounts Service v33 Sage 50 Accounts Control v33
Sage Accounts v32	Sage 50 Accounts Service v32 Sage 50 Accounts Control v32
Sage Accounts v31	Sage 50 Accounts Service v31 Sage 50 Accounts Control v31
Sage Accounts v30	Sage 50 Accounts Service v30 Sage 50 Accounts Control v30
Sage Accounts v29	Sage 50 Accounts Service v29 Sage 50 Accounts Control v29
Sage Accounts v28	Sage 50 Accounts Service v28 Sage 50 Accounts Control v28
Sage Accounts v27	Sage 50 Accounts Service v27 Sage 50 Accounts Control v27
Sage Accounts v26	Sage 50 Accounts Service v26 Sage 50 Accounts Control v26

Select Stop, right-click again, then select Start.

▼ Restart the computer where your data is held

Contact your local IT support if you need any assistance with this.

▼ Ensure all updates are installed

This message appears if you install an update on some of your computers but not where you hold your data. Download and install the update on all computers:

Sage Accounts v28 and above - No update needed
Sage Accounts v27 - Sage 50 Accounts v27.1 update
Sage Accounts v26 - Sage 50 Accounts v26.3 update

▼ Disable 'Use FIPS-compliant algorithms for encryption'

Press the Windows key + R.
In the Run window, enter >secpol.<>msc then press OK.

The Local Security Policy windows appears.
Expand Local Policies and click Security Options.
Scroll down and double-click System cryptography: Use FIPS-compliant algorithms for encryption, hashing, and signing.
Select Disabled then press OK and close the Local Security Policy window.

▼ Clear the contents of the .Net folder

You can resolve installation issues by deleting the contents of the .Net folder.

NOTE: Stop the Data Service or lock Remote Data Access before you delete the contents of this folder.

Browse to the folder:

C:\Windows\Temp\.net

NOTE: You require Administrator permission to access this folder.
To select all files and folders within the .Net folder, hold down Ctrl + A.
To delete the files, press Delete then Yes.
Try to open Sage Accounts again.

▼ Check for a network password

On the client computer, hold down the Windows key and press R.
Type \\ and the IP address of your server, for example \\123.456.121.323
Press OK and, if prompted, enter your network password.
Open Sage Accounts again.

▼Configure your firewall

If the service is running but the error message still appears, then configure your firewall.

Check your firewall doesn’t block the Sage Accounts Data Service by ensuring the following ports are open:

Version	Sage 50 Data control service	Sage 50 Data service
Sage Accounts v33	TCP 34233	TCP 32333 & 32233
Sage Accounts v32	TCP 34232	TCP 32332 & 32232
Sage Accounts v31	TCP 34231	TCP 32331 & 32231
Sage Accounts v30	TCP 34230	TCP 32330 & 32230
Sage Accounts v29	TCP 34229	TCP 32229 & 32329
Sage Accounts v28	TCP 34228	TCP 32328 & 32228
Sage Accounts v27	TCP 34227	TCP 32227
Sage Accounts v26	TCP 34226	TCP 32226

You can configure the ports for specific IP addresses. On the server, add the IP addresses for the client computers to the inbound and outbound rule for the port. On the client computers, add the IP address for the server to the inbound and outbound rule for the port. You can't apply this when using dynamic IP addresses.

▼ Steps to add inbound and outbound rules to the Windows Firewall

Use this process to add inbound and outbound rules to Windows Firewall for the Sage Accounts Data Service. In Step 3, choose Inbound Rules or Outbound rules as appropriate.

On your computer, go to Start, enter Control, then press Control Panel, System and Security.
Select Windows Firewall.
From the left-hand column, select Advanced Settings, then Inbound Rules and New Rule. To add outbound rules, press Outbound Rules, then New Rule.
Select Port and press Next.
Select TCP and Specific Local Ports and enter the relevant port numbers:
- Sage 50 Accounts v33 - 34233, 32233
- Sage 50 Accounts v32 - 34232, 32232
- Sage 50 Accounts v31 - 34231, 32231
- Sage 50 Accounts v30 - 34230, 32230
- Sage 50 Accounts v29 - 34229, 32229
- Sage 50 Accounts v28 - 34228, 32228
- Sage 50 Accounts v27 - 34227, 32227
- Sage 50 Accounts v26 - 34226, 32226
Press Next.
Select Allow the connection and press Next.
Select all the checkboxes: Domain, Private and Public.
Enter a name and description for the rule: Sage Data Service then press Finish.

▼ Check your data path, folder permissions and run the software as admin

There are several areas to check in terms of access and permission, follow the steps below:

▼ Check for any mapped drives and change to UNC path

Open Sage Accounts and from the Select Company window, note the data path, then click Cancel.
Press the Windows key + E browse to the path you noted.
Check that the path isn't a mapped drive or none of the folders in the path are Windows shortcuts.
If your data path is a mapped drive or shortcut, check the full path to your data, then go to step 5.

Press the Windows key + E and browse to the following location on the computer where you use Sage Accounts:

Sage 50 Accounts v33	C:\ProgramData\Sage\Accounts\V33
Sage 50 Accounts v32	C:\ProgramData\Sage\Accounts\2026
Sage 50 Accounts v31	C:\ProgramData\Sage\Accounts\2025
Sage 50 Accounts v30	C:\ProgramData\Sage\Accounts\2024
Sage 50 Accounts v29	C:\ProgramData\Sage\Accounts\2023
Sage 50 Accounts v28	C:\ProgramData\Sage\Accounts\2022
Sage 50 Accounts v27	C:\ProgramData\Sage\Accounts\2021
Sage 50 Accounts v26	C:\ProgramData\Sage\Accounts\2020

Double-click the Company file and choose to open with Notepad.
Change the path in the Company file to use the full data path without the shortcut. Enter the relevant UNC path for this. For example, if your data is on a computer called Server and your shared folder is Sagedata, the UNC path is \\Server\Sagedata.
Go to File and select Save.
Go to File and select Exit.

▼ Check the user's Windows permissions

Use our Windows permissions and Sage 50 Accounts guide.

▼Add security permissions to your data folder on the server and client computers

On the client computer, open Sage Accounts.
In the Select Company window, make a note of the data path for the relevant company.
Browse to the folder that contains your data folder. For example, if the path noted in step 1 is s:\sage data\company.001, browse to s:\sage data\

If you're prompted, enter your network password.
Right-click the data folder, in our example s:\sage data\company.001 click Properties then select the Security tab.
Select Advanced, then Change Permissions and Add.
Select Object Types and select the included Computers and Services/Service Accounts, then press OK.
In Enter object name to select, type system then click Check Names, select SYSTEM then press OK.
Click OK then under Allow select Full control, click OK, click Apply then click OK.

▼ Run the software as an administrator

To do this, right-click the shortcut then click Run as administrator.

To permanently set the shortcut to run as administrator:

Right-click the shortcut, click Properties and click the Compatibility tab.
Click Privilege Level and select Run this program as an administrator then click OK.

▼ Delete the queue.dta file

TIP:

Use our Data Service Manager that makes this process easier. To find out more, visit our using the Sage 50 Data Service Manager in v31 and above article.

Delete the queue.dta file to rule out any issues with this file.

NOTE: Stop the Data Service or lock Remote Data Access before you delete or rename any files or folders.

Open Sage Accounts.
From the Select Company window, select the relevant company and click Open Folder Location.
Open the ACCDATA folder and delete the QUEUE.DTA file.

▼ Check access to the required IP address

Amend the Sage Accounts company file to use your server's IP address, providing the IP address is static.

Check the IP address on the server

At the server computer, click Start, then click Control Panel.
Press the Windows key + R and enter CMD, then enter ipconfig /all
The IP address appears next to IPv4 Address, look for the 'Preferred' option. If there’s more than one, note them all.
At the client computer, connect to the server using the IP addresses you noted in step 3. The system can ask you to enter network credentials. This is the Windows password for the server.

Amend the company file to use the IP address on your computer

Browse to the relevant folder:

Sage Accounts v33	C:\ProgramData\Sage\Accounts\V33
Sage Accounts v32	C:\ProgramData\Sage\Accounts\2026
Sage Accounts v31	C:\ProgramData\Sage\Accounts\2025
Sage Accounts v30	C:\ProgramData\Sage\Accounts\2024
Sage Accounts v29	C:\ProgramData\Sage\Accounts\2023
Sage Accounts v28	C:\ProgramData\Sage\Accounts\2022
Sage Accounts v27	C:\ProgramData\Sage\Accounts\2021
Sage Accounts v26	C:\ProgramData\Sage\Accounts\2020

Double-click the Company file and choose to open with Notepad.
Change the paths in the company file, replacing the server name with the IP address. For example, if your server IP address is 123.456.789.111, and your shared folder is Sagedata, the UNC path is \\123.456.789.111\Sagedata
Go to File and select Save.
Go to File and select Exit.

▼Clear the Domain Name Server (DNS) cache

The Windows DNS cache stores your recently viewed pages by IP address. You can’t access the page if its location changes before you update the entry in your DNS cache. The IP address for the Sage Accounts Data Service is dynamic, which means it can change. If the DNS cache stores the IP addresses and doesn't update, this causes a connection issue to the service. Clearing the DNS cache can resolve this.

Stop the Sage Accounts Data Service.
Press the Windows key + R and type ipconfig /flushdns then press OK.
Start the Sage Accounts Data Service.

NOTE: Use our Download and install the Sage Accounts Data Service article to start or stop the Sage Accounts Data Service.

▼ Install the full software on your server

Instead of just the Sage Data Service, install the full software on your server to check if it can connect to data when installed locally.

For help with installing, visit the Install help centre.

▼ Check if the server has both Sage 50 Accounts and the separate Sage Accounts Data Service installed

NOTE: Ensure you have a current backup of your Sage 50 Accounts data before following the steps below.

On the server computer, press the Windows key + R and type Control Panel then press Enter.
Under Programs and Features, look for Sage 50 Accounts and the Sage 50 Accounts Service.

If both Sage 50 Accounts and the Sage 50 Accounts Service appear in the list, you must uninstall both, then reinstall only Sage 50 Accounts.

Select the Sage 50 Accounts Service and select Uninstall.
Press Yes then Finish.
Select Sage 50 Accounts, select Uninstall, then Remove.
Press Next then OK.
Press OK then Finish.
Reinstall Sage 50 Accounts.

For help with installing, visit the Install help centre.

▼Check key permissions - Sage 50 Accounts v28 or above

If you're using Sage 50 Accounts v28 or above, as an additional step, check the Data Service key permissions.

Further Troubleshooting steps

We advise that your local IT support follow these steps.

▼ Remove read only and hidden attributes

Obtain the address of company.0** folder, for example S:\SageData\Company.000.
Start click Run, then type CMD then press OK.
Type CD and the path to the data, for example CD S:\SageData\Company.000, then press Enter.
Type attrib -h -r /S /D then press Enter.

The -h removes the hidden attribute
The -r removes the read-only attribute
The /S ensures this applies to all files in the folder
The /D ensures this also applies to all the sub folders

Close the command prompt window.

▼ Check access to the required IP addresses

Check the following:

Test access to 127.0.0.1 (local PC) to check for tcp/ip faults on your network adapter
Test the server IP address from the client computer. This ensures they're not using a distributed file system and that the data service is installed where the files are being distributed from

To test access to the IP addresses, you require on the client computer:

Start click Run, type CMD, then press OK.
At the Dos prompt, type ping 127.0.0.1, then press Enter.

For the server, repeat this replacing 127.0.0.1 with the server IP address.

To check the server IP address on the client computer:

Start click Run and type CMD, then press OK.
Enter ping servername then press Enter.

If you receive the following message, the system can't find the data service on the server or there's a fault with the network adaptor:

'Ping request couldn’t find host xxxx.sage.com'.

Update the File Path Using the IP Address

Locate your company file from the following path, the C: to location data is stored on.

Sage Accounts version	Default data path
Sage Accounts v33	C:\ProgramData\Sage\Accounts\V33
Sage Accounts v32	C:\ProgramData\Sage\Accounts\2026
Sage Accounts v31	C:\ProgramData\Sage\Accounts\2025
Sage Accounts v30	C:\ProgramData\Sage\Accounts\2024
Sage Accounts v29	C:\ProgramData\Sage\Accounts\2023
Sage Accounts v28	C:\ProgramData\Sage\Accounts\2022
Sage Accounts v27	C:\ProgramData\Sage\Accounts\2021
Sage Accounts v26	C:\ProgramData\Sage\Accounts\2020

Right-click on the "COMPANY" file, and select Open with.
Choose Notepad and press Just once if it gives you the option.
Replace the start of the data path with the IP address before the backslash "\".
Go to File then select Save.

▼ Check for mapped drives on a computer and change to UNC paths

TIP: This also advises how to get the IP address of the server.

Press the Windows Key, type cmd, right-click cmd.exe, then choose Run as admin.
Type Net use then press Enter.

This shows all mapped drives for the computer you run the command on.
To get the server IP address, enter nslookup server name.
Change any mapped drives to UNC paths.

▼ IPv6 addressing

In some circumstances, the problem is related to the customer using a IPv6 IP address. To resolve this either switch to the IPv4 IP address, or disable the IPv6 address on the local network. For further help with this, refer to your local IT support.

1. Hold down the Windows key and press R.

2. Type Control Panel then select Network and Internet.

4. Select Network and Sharing Centre, then Change adapter settings.

6. Right-click your connection and go to Properties.

7. Clear the Internet Protocol Version 6 (TCP/IPv6) checkbox.

Solution Properties

Solution ID: 200519133711686
Last Modified Date: Wed Jan 21 09:55:37 UTC 2026
Views: 0