Remote connection to Analysis Services 2008
Posted on 2009-07-05
I have a Windows 2008 Server x64 with SQL 2008 x64 configured with fully working reporting services and Analysis Services locally.
I try to connect to from localhost everything works. Creating and browsing reports that are using the analysis services datasource.
But when I try to connect from remote it fails.
Report manager says: "Query execution failed for dataset 'dataSet'."
Excel 2007 connection wizard just cannot connect to the server.
If I use SQL as source, it works fine. But not when using analysis services.