Sage 100 2022 Premium Crystal Reports Database Login Failed. Unable to connect: Incorrect log on parameters

Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error.

When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx.rpt: Unable to to connect: incorrect log on parameters." 

Steps we've taken to resolve/review

  • Confirmed SQL login is correct through SQL utility. 
  • No Firewall is turned on. 
  • Updated Antivirus exclusions and paths
  • Ran workstation As Administrator
  • Logged into SQL using MAS_Reports login.
  • Review SQL database permissions for MAS_Reports
  • Created a ODBC using SQL Server Native Client 11 connection from workstation without issue. 
  • At workstation, opened custom crystal report through Sage Report Manager, updated database, tested and confirmed data, saved. Still could not run crystal report through custom reports menu. 

Any suggestions would be helpful. 

Parents Reply Children
No Data