I have a database external to Epicor that contains a stored procedure I need to execute. It does not return any data, just runs a process. I know that I can connect to the external data source and run a query. I have seen on this forum that you can’t do an exec from Epicor to run one. I tried to create an SSRS report to run it, but I am having issues connecting to the database. I have set up a Report Style and a shell RDD to call it but I am getting an error “One or more data source credentials required to run the report have not been specified”. We have set up a user account for our SSRS reports to run with the Shared Report Data Source user id and password but I keep getting this error. How would I set up running the stored procedure from Epicor?
I discovered that I didn’t have the credentials for the external database set right. I needed to select “Use current Windows user” for the dataset in the report. Once I did that it worked!