Apr
3
2012

Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

When you try to connect to SQL Server OLAP services hosted on a server from your desktop or client machine then it will require appropriate drivers to connect to SQL Server Analysis services.Microsoft releases feature pack with every SQL version which include drivers for installation on client machines, you can download them as appropriate.

Look for section, “Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® < < Version >>” at following links,

For SQL Server 2012: http://www.microsoft.com/download/en/details.aspx?id=29065

For SQL Server 2008 R2: http://www.microsoft.com/download/en/details.aspx?id=16978

For SQL Server 2008: http://www.microsoft.com/download/en/details.aspx?id=8824

For SQL Server 2005: http://www.microsoft.com/download/en/details.aspx?id=15748

Download drivers from above location and install to get things working.

Useful reference featuring details about SQL Server feature packs: http://www.dbi-services.com/index.php/blog/entry/sql-server-2012-feature-pack

Download PDF

Related Posts

About the Author: Nitin Garg

Indian born, trekker, biker, photographer, lover of monsoons... I love to blog the topics I research and find useful for self or online community to save time and energy :) Everything you read on my blog is my own personal opinion!

3 Comments + Add Comment

  • I am trying to connect SSAS 2008 cubes using excel 2003. Can you please let me know whether ‘microsoft ole db provider for analysis services 10.0 ‘ works in windows 2000 systems?

    • Hi Kunal, you cannot installl this driver on windows 2000 as minimum system requirement is win 2003 and above, pfb excerpt from MS website,
      “Supported operating systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP”

  • Sweet blog! I found it while surfing around on Yahoo
    News. Do you have any tips on how to get listed in Yahoo News?
    I’ve been trying for a while but I never seem to get there!
    Thanks

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 174 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

May 2019
M T W T F S S
« Nov    
 12345
6789101112
13141516171819
20212223242526
2728293031  

View Post by Categories

%d bloggers like this: