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

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

Solution Properties

Solution ID
241030211725730
Last Modified Date
Wed Sep 23 23:31:11 UTC 2026
Views
0