RangerMSP Business Automation for successful ITs

 
December 12th, 2022, 03:07 PM
lwilson
 
Posts: 101
Once we got our servers and workstations back up from a power outage we are now getting this error ONLY on our workstations. I can open commit on the server and the online is working:
"Procedure halted due to data server access error. Verify server is operating and this computer has access to the server folder (\\...CommitCRM\DB)."
All workstations have access to the server and access to the folders
Any help would be appreciated
 
December 13th, 2022, 06:04 AM
Support Team
 
Posts: 7,510
Thank you for posting this.

The error "Procedure halted due to data server access error" is related to the auto discovery process of the SQL back end that fails.

When the client app launches it broadcasts a UDP packet for the server to answer letting the client know where the SQL server is.

First, please verify that the 'Advantage Database Server' service is running on the server.

One of the possible reasons for this error is incorrect server IP and/or Port configured in ADS.ini file located under <installation-folder>\LastVer and <installation-folder>\Client folders. Please review the settings in this file (in case you find it, not all setups have it). You can send us ADS.ini for review.

It is also possible that UDP packets are filtered between the client and server machine.

Please try allowing UDP in the Windows firewall of the PCs and on the server.
Especially verify that ADS.exe (the executable of Advantage Database Server) is allowed in the firewall.

I hope this helps!
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search



All times are GMT -6. The time now is 08:32 AM.

Archive - Top    

RangerMSP - A PSA software designed for MSPs and IT Services Providers
Forum Software Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.