Cannot find DSN in connection string

[AntonioPerera]

ACCPAC 5.3
Windows Server 2003
Terminal Services
MS SQL 2005

I have created a custom report in Crystal utilising tables from Peresoft Cashbook.

I have placed my report on the ACCPAC desktop but when I try to run the report I get the following error message :

Logon Failed
Details : Cannot find DSN in connection string

I have created a system DSN which gives the Windows user rights to the database from which the data is pulled out and ensured that the Windows user is a public and dbowner in SQL but this still did not resolve the issue.

Any ideas on what to do next ?

 

[Jay Converse]

When you put RPTs on the Accpac desktop, don't use Windows authentication, and don't use non-Accpac tables.