We are also having this issue, did you find a solution? I'm thinking I need to redo process set?
We have a few Crystal reports that utilize a Stored Procedure and all of a sudden users are getting a Database Login popup that is calling for a password. When they click the ok button and Application error displays stating an "Invalid login" for (Login:userID:server:database:table) = lists the user id: "sysprogress":"LSIEPICOR9":"epicor905":""usp_Lists the Stored procedure name:1".
Nothing has been changed with network security, so we are completely puzzled by this. There are a couple of reports that users could run yesterday morning, and later in the day they could no longer run them.
Any ideas, suggestions?
Thanks all.
Carol