SSRS report cannot connect to SSAS cube once deployed
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.
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.
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).
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?