Skip to content
logo Knowledgebase

Error: "The database login failed. Unable to connect: incorrect logon parameters."

Created on  | Last modified on 

Summary

The error occurs when running any report in Sage 100 ERP using SQL

Resolution

This resolution applies to Sage 100 ERP Premium; the SQL Server edition.
Solution One: 
No Database Vendor Code presents in the error message.  Note:  This solution resolves issues affecting multiple reports, not a single report.
  1. Uninstall the Sage 100 workstation client from the machine
  2. Temporarily grant the Windows user, Domain Administrative rights
  3. Reinstall the Sage 100 workstation
  4. Log into Sage 100 and run a report
  5. Remove user's domain administrative rights. Verify the error doesn't occur

Solution Two:

Make sure that the SQL Server Browser is running and the Inbound Firewall Rule for UDP Port 1434 exists on the SQL Server