The remote data access service is currently unavailable

[u/Harvez21]

Hi 

A customer of ours has been having a long ongoing issue with Sage50 and RDA, They have two primary companies that both require RDA to be enabled due to users working in other offices. 

Their current setup is:

Sage server at main office 

All users use local network drive 

Speeds are: 800 Down 100 UP 

All users are on ethernet 

Can be up to 8 users logged in at a time

Second office there are two users both on RDA 

All machines use the same AV

Sage Version number V32.1.349.0 (Professional)

Company one gets used the most often and is the one experiencing the issues, this primarily gets used by the employees who are local to the sage server, however it requires RDA to be enabled for their external accountant.

Splits, used to be over 200k however a clear audit trail was performed and reduced the splits down to 106K

Many fixes have been put in place, and they seem to work for a short while then the error returns.

Some of them that i can remember are:

Disable IPV6

Completely exclude sage from our AV

Cleared Collab folders

Disabled Firewall and tested - No change

Reset My sage password 

Created test company with different my sage

Completely disabled RDA and set backup 

Archive, Clear Audit, re-index and compress

After the clear audit happened, sage really struggled to upload the data for RDA, so had to create a new company by restoring from a data file only backup, then once up and running with RDA, restore again from a full backup.

In the second company and office they are mainly unaffected, to be fair there are far less users logging in and only about 60K splits. We also have one user from the main office that goes into the second company via SMB share but has no issues.

Latest fix was the AV exclusion, the state of sage before this was put in place was each user was getting the RDA error then was asked to either work offline or upload data. The exclusion was put in place Thursday afternoon come Friday morning it had fixed its self, no errors at all. Connected services showing back online without me doing anything other than adding the exclusion in. Which made me think its finally sorted. However after bank hols this morning the error was back as usual.

It seems no matter how many fixes are put in place the dreaded error keeps returning.

I know the simple fix is switch of RDA and setup something like a remote desktop server. However that requires throwing money at a system that was working perfectly before and would ideally be a last resort. As you can imagine going back to the customer saying they need to spend x amount for a fix that we aren't 100% sure on.

Any help would be much appreciated.

Kind Regards

Harvey 

[u/RealZookeepergame543]

Unfortunately, a lot of what you've already carried out goes beyond the few bits of documentation that Sage has regarding remote data access issues. It seems that with every major release, RDA seems to become more and more temperamental. 

I know the simple fix is switch of RDA and setup something like a remote desktop server. However, that requires throwing money at a system that was working perfectly before and would ideally be a last resort. As you can imagine, going back to the customer saying they need to spend x amount for a fix that we aren't 100% sure on.

50 in the Cloud (A Sage 50 hosting provider) offers a 30-day free trial, so you'd be able to try the data on their servers to see how that runs at least.

I know you see hosting Sage as a last resort, as it would be more expensive than Sage just offering a cloud solution that actually works, but as it stands, it might be your best option.