Trying not to duplicate a question that has already been asked.
I have a crystal report that can be run from Sage and interactively that does not use any work tables, but when attempting to run it from a KnowledeSync report in 10.5 version I get a Database login failed. This will occur whether I am using a soft login using a DSN that I have created with the SOTAMAS90 driver or with SQL credentials to the linked server, almost as if the credentials were being erased.
The application that contains the event which runs the report connects successfully to the Linked Server and I can read the tables from SQL Server Management Studio.
I have not tried to use the KLF approach, which seems to be only available in the 9.0 version since many have indicated that this was not necessary.
The underlying Sage I am connecting to for now is Providex.
This report ran well for years in 9.0. It is a very basic report that does not require any run time parameters, just a logon.
Thanks very much in advance.