When i try to connect sql 2008 R2 analysis service using OLAP control then i get following error
"Either the user, IIS APPPOOL\DefaultAppPool, does not have access to the PDW test database, or the database does not exist."
Here is connection string that i used: <add name="OlapDB" connectionString="Provider=MSOLAP;Data Source=PCT86\PCT86_R2;Initial Catalog=Adventure Works DW;Persist Security Info=false;Integrated Security=SSPI" />
can anyone let me know where i am wrong!!!
View Complete Post