Hi,
I have 2 cubes processed and deployed successfully on a 2003 server (SSAS 2005) . (I do get an attribute key error but I am turning it off using Custom Error Configuration). I am connecting to the cubes using OWC 11 pivot table viewer and OWC 11 Chart Viewer. These are deployed on a SharePoint Server Portal, which is hosted on the same server. As long as I view the sharepoint pages on the same server, the charts and tables display fine. When I use the browser from a different machine on the same domain to view the pages, I get the error mentioned in the subject line.
The error code is 0x80004005. I tried many different things like security settings etc but it keeps showing up from any machine on the domain, other than the server on which sharepoint and ssas 2005 are hostes. Please help, this is very urgent.
Regards
Sharath
The Query Could not be processed. The data provider didn't supply any other error information (SSAS 2005, SharePoint, OWC 11)
thaoula
Probably all that would be required client-side would be the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider - a redistributable version of which can be found here: http://www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en . Not sure whether you're using HTTP or direct OLAP to connect your clients to the cube, but if you're not using HTTP then it would be advisable so access via your portal can be given to people outside your LAN (if required). Instructions for that are here: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
Glad you managed to get it working on some machines.
cheers,
Miles
RobertW
I tried connecting to a few cubes on SQL Server 2000 Analysis Manager and I could connect well as well as view the data on OWC Pivot Tables successfully. When I try creating a new data source that connects to SSAS 2005, I get an error "SQL Server does not exist or access denied". The only way I am able to create a data source is when I do it by opening the OWC Pages on the server that has SSAS 2005 installed. And of course, the data on these pages does not show up when I use the browser to view the page from other machines. SQL Server 2000 cubes and data work fine in all circumstances though.
Looks like it boils down to either a security issue, or more likely, a Data Provider compatibility issue. Any ideas
Thanks in advance
virnoche
I haven't had this particular error, but I've had problems in similar kinds of arrangements before wherein the authentication was not working transparently (ie, the user's windows credentials were not being passed through to the backend database as they should). Two things to try are:
1) Adding the sharepoint portal to your trusted sites (although probably you've tried that in your attempts to fix it)
2) On the domain controller, make the sharepoint and analysis server machines "trusted for delegation" (which is set in the relevant computers' properties in "Active Directory Users and Computers").
...just a couple of things to try, hope it works... Good luck!
Nani
I think I finally got it. I tried opening the site on a machine with SQL Server 2005 installed and it worked fine. I guess we somehow need to get MSOLAP 9.0 running on the machine to view data from SSAS 2005 cubes, and installing SQL Server 2005 is a sure way.
Alternatively you can re-register msolap90.dll if you installed Office 2003 AFTER you installed SQL Server 2005. I havent tried just registering msolap90.dll and all its dependencies by themselves without intalling SQL Server 2005 but I am guess that'd work too.
Thanks everyone.
Guido Pica MSFT
Thank You Miles.
I will let our systems manager know about this. I am also trying a few other things, like trying to connect to cubes on SQL Server 2000 Analysis Manager. I have a feeling this will work.
Thanks again
Sharath