I am running Sage Accpac version 5.5 on a 64 Bit windows 2008 Virtual server.
The database is SQL 2005 and reside on a different physical server. I created various customized reports using Crystal Reports XI. These reports were created by linking to views that was created in the SQL database. I link to the database with a ODBC (RDO) connection for all the reports. I can run all the reports from the Crystal Reports designer. However when I want to run them from the Accpac desktop I get the following error when running some of them
Logon Failed Details: [Database Vendor Code:18456]
Strangely enough the reports are all linked to the database in exactly the same way (ODBC) the only difference is that use different views.
Advice on this issue will be much appreciated.