BAASS Insights Technology Blog

Error Message: 'Invalid Database Specification'

Written by BAASS Author | Aug 24, 2019 6:48:00 PM

Problem Details:

The following error message may be received when logging into a Sage 300 ERP Company:

"Invalid Database Specification"

Solution: 

This message occurs when Sage 300 is opened. When the program is opened, it attempts to connect to the data.  This error indicates a connection problem.

One of the following will normally resolve this error:

  1. User may have insufficient rights: turn off the UAC controls, and / or give the user local administrator rights.
  2. Check database setup.  Ensure the connection is made using the SQL server name, not an odbc data source connection.
  3. Disable the firewall that may be blocking traffic.  If that resolves it, enable the firewall and make an exception to allow the program through the firewall.
  4. Re-install or repair the SQL Native Client driver