DB error after power outage

[lwilson]

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

[Support Team]

Re: DB error after power outage

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!