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

Summary

Occurs when running any report in Sage 100 ERP using SQL

Resolution

This resolution applies to Sage 100 ERP Premium; the SQL Server edition.
No Database Vendor Code presents in the error message. This solution may not resolve issues with a single report.
  1. Uninstall 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 is resolved.

Solution Properties

Solution ID
241030211725730
Last Modified Date
Wed Oct 30 21:17:25 UTC 2024
Views
0