I'm trying to connect to an OLAP cube on our SQL Server 2005 machine which is running Analysis Services (9.0). When I am trying to use the Crystal Reports menu in Visual Studio and selecting 'Crystal Reports', 'Database Expert', 'Create New Connection', 'OLAP', 'Add', the only Analysis Services option I get is for Microsoft OLE DB Provider for OLAP Services 8.0 which is SQL Server 2000. I cannot get the 9.0 provider to show.
HOWEVER: If I am in Crystal Reports itself and try to connect to Analysis Services 9.0, the option is there and I can connect. Note that if I try and then run this report from inside Visual Studio via Crystal Report Viewer, the report fails probably because it does not know where the 9.0 provider is....?
Microsoft Visual Studio 2005 Professional
Version 8.0.50727.762 (SP.050727-7600)
Crystal Reports XI Release 2 Developer Edition is also installed.
I've also installed a Crystal Reports patch form Business Objects called
'Crystal Reports XI Release 2
Support for MS SQL Server
2005 Analysis Services'
Any help?
I had this same problem, install the OLEDB 9.0 driver for analysis services on the server where BO lives:
http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en
That's only half the battle, you have to setup an spn for anaylsis services, trust things for delegation. You'll have to get a friendly domain admin to help. Here is a great white paper the BO support refered me to:
http://support.businessobjects.com/communityCS/TechnicalPapers/bo_voyager_xi_r2_configuring_msas_security.pdf
No comments:
Post a Comment