Security Settings for shared data source on Report Server

Epicor ERP 10
1

Hello all,

We are currently upgrading from 10.1.400 to 10.2.

I have successfully deployed our custom reports to our upgraded TEST environment and they run fine within our upgraded environment. I can access our new report server and can see all my custom reports. I downloaded Report Builder and can open my reports and see structure. But when I try to run the report from within Report Builder, I get an error connecting to the shared data source:

image
image.png855Ă—482 11.7 KB

I looked at the data source for the report on the new report server:

image
image.png803Ă—569 19 KB

These are the properties on the Shared Data source:

image
image.png765Ă—784 26.9 KB

but when I test connection, I get this error:

image

I appear to have full Security access (aholsomback)

image
image.png1267Ă—472 22.2 KB

I need the ability to edit my reports in Report Builder, so I need to figure out where my credentials are failing.

Just for the record, these are the properties on our current (not upgraded) 10.1 report server:

image
image.png853Ă—772 39.5 KB

Any thoughts?

Thanks,

Alice

2

That is an SQL permissions issue (as opposed to the SSRS permissions).
Its stating you do not have read access to the Database.

3

When you open a report in Report Builder… do you see more that one shared data source listed?
If so, I’ve fixed a few of my reports that were in this state…
Data Sources → Right Click → Data Source Properties
Then verify/fix one shared datasource, and delete the other one.
Ref screen shot…
image

SSRS…

1 Like
4

Thank you…I don’t see any other data source in report so I’m thinking its my SQL credentials.

image
image.png692Ă—505 14.1 KB

5

Yes, may be… have you already tried to log on to the server as an admin and edit reports?

Also with the datasource…
What happens if you click the “Test Connection” button?
Or, if you click the “Browse” button - are you able to navigate to the displayed path and select it?