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:
- User may have insufficient rights: turn off the UAC controls, and / or give the user local administrator rights.
- Check database setup. Ensure the connection is made using the SQL server name, not an odbc data source connection.
- 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.
- Re-install or repair the SQL Native Client driver