We are using Sage 300 (Timberline) and connected to Microsoft SQL Server. I wrote a stored procedure, connected it via odbc and create the report in Crystal 11. In preview mode, the report runs perfectly. I then added it to the menu in Timberline and get the error:

Logon failed.
Details: [Database Vendor Code: 18456 ]

It isn't a logon issue though. I traced it down. I found that checking the option in the File menu to "Save Data with Report" makes the error message go away in Timberline. However, that isn't what I want. I want the newest data, not something saved in the report.

Any ideas would be appreciated.

In my case, when leaving "Save Data with Report" checked, it never runs the stored procedure again. So, if the user just prints the report, it will be old data. I tried running the report in "Preview" mode and there is no refresh button on the view to get the new data. So, I really can't have "Save Data with Report" checked.

Ahh. That helped. I did some looking and the database is set up with windows and sql authentication. I looked in the error log and it stated "Login failed. The login is from an untrusted domain and cannot be used with Windows authenitication. " What this is telling me is the ERP system is only passing a Windows Authenticated (Integrated) login. Hmmm. I don't know how to get by this one...