Logon failed. Unable to connect: Incorrect Logon Parameters

[francis2299]

Hi All

I created a report using crystal report, when I Preview in Crystal report and Refresh. It displays perfectly, see attached picture 2.
But when I try to run it in Accpac the below error (see attached Picture 3) display:

Logon failed.
Error in file {Crystal report}.rpt
unable to connect: Incorrect logon Parameters.

Your help is highly appreciated. I am using SQL Server 2008 Database, Sage 300 ERP 6.2
Windows 7 operating System.

For Clarence please find attached file.

Thanks and regards
Francis

 

[Jay Converse]

Make sure you connect only to Accpac tables, and using an ODBC DSN with a login ID and password, not Windows authentication.