SSRS report cannot connect to SSAS cube once deployed

0
votes

I have an SSRS report that connects to an cube using a shared SSAS data source with integrated security. In visual studio the report works fine and connects successfully. Once I deploy it to the report server (sharepoint 2013 integrated/sql 2012) then it won't work and gives an access denied error.

enter image description here

My user is an admin on the SSAS instance so security is not the issue. Can connect fine with ssrs in visual studio, excel, ssms. Only once the report is deployed and run in sharepoint it doesn't work. Similar error if I go to the data source in sharepoint and try to test the connection.

enter image description here

1
sql-serversharepointreporting-servicesssasssrs-2012
Are you deploying datasource too? – alejandro zuleta
It's already deployed. I did deploy it again just to make sure. – Brandon Frenchak
Go to SSRS site and open datasource properties, check the credentials used for connection. Actually these credentials will be used to connect to SSAS. – alejandro zuleta
I ended up doing stored credentials, and then setting security in sharepoint on the report and data source. Not sure if this is a better solution or not, but it works. I would still be interested to figure out why the integrated security is failing just once deployed to sharepoint, as this should work as well. – Brandon Frenchak
That's a workaround I used too, I faced the same issue it is known as double-hop errors. Check this – alejandro zuleta

1 Answers

0
votes

I believe the problem was that even though my user had permissions. Using integrated security causes a double hop problem (computer ->report server -> db server) in order to authenticate. By using stored credentials on the report server is solves the double hop problem (report server -> db server).