Project Server 2007: "You must have the valid Analysis Services database name and cube name."
I know how long you took to setup analysis services (if you did a server farm environment deployment with App and Web Server on a separate box and SQL on another) and now you run into this error when you try to create a new view and connect to the cube.
You get the fallowing error: "You must have the valid Analysis Services database name and cube name." It's not the best feeling in the world.
I took a look at this link, they said that it's all about enabling "Access data across domains" in Internet Explorer (Tools > Internet Options > Security > Trusted Sites > Custom Level). I just say add the PWA URL to your Trusted Sites.
I tried that and it didn't work. I'm quite sure the full working solution would be:
- Ensure Office Web Components are installed.
- Install Microsoft Core XML Services (MSXML) 6.0
- Install Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
- Ensure that PWA URL is added to your Trusted Sites
The MSXML and OLE DB can be downloaded from here.
4 comments:
The key here is enabling "Access data across domains" from in the "Trusted Sites" section of your security settings (if you have added your pwa site as a trusted site)
Thanks a lot? your advisec are very helpful!!
Apart from this, Please make sure you install SQLServer2005_ASOLEDB9.msi on the server hosting PWA (if SQL Server is different from PWA Server). For me this was missing.
Nice One!
I came across this issue, it ended up being the SQL OLE db9 download add-on we needed, for each workstation.
Also, we use the intranet zone instead of trusted zones. This zone is there for a reason and should be used, otherwise you just end up recreating the settings in the trusted zones which are already available in the intranet zone.
Post a Comment