Connection to Analysis Server 9.0 option missing

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

Connection to Analysis Server 9.0 option missing

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

Connection question

I am running through a tutorial book to learn the basics on Cubes and OLAP, however I am at a part where I have to add some calculations and I get the error: 'A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running.'. The cube must be queried for you to browse data or meta data.'

And then I have tried to Deploy the project and I get this same error.

I am a beginner at this, but not really SQL Server 2005 overall. What did I miss here? I have a data source that is connecting to the SQL Server database just fine.

Thanks for the information

Hello! I have never experienced the same problem but I tried www.live.com with the same error message:

Some information about this problem can be found here:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

Dou you have SSAS2005 and SQL Server 2005 on the same machine?

Kind regards

Thomas Ivarsson

|||I do have it on the same machine. But when I tried to connect to an Analysis Services instance, I don't find any. So I take it that has to be part of the SQL Server setup.|||

Hello again. Have you deployed a cube succesfully before this error?

If not, what kind of impersonation mode are you using for the data connection?

Regards

Thomas Ivarsson

|||

This is my first "example" cube so no, I have not yet deployed a cube to the server. This is only a development machine so it is "safe" to use. I do have a local instance of SQL Server 2005 SP2 running.

I am using the credentials of the current user for impersonation.

|||

If you go to the top level in the solution explorer in BI-Dev studio, right click, choose properties and check the deployment option in the tree(lowest level).

If you enter localhost or your computer name there and the deploy the project?

HTH

Thomas Ivarsson

|||I've always used "current service account" to deploy test cubes on my local machine.|||

I really think this has something to do with the way that this SQL Server instance is set up. I am going to work with our network guys on this. I realized that my local verion of SQL server is 2000, not 2005 as I have been developing on.

But thanks for the information.