Resolving : Server is either too busy or not responding in SQL Server 2005 Analysis Services

 

I recently faced this error while connecting to Microsoft SQL Server 2005 Analysis services from Microsoft

Excel 2007. Inspite of the several solutions given on various sites none of them seemed to work.

 

The solution was simple, you need to install Microsoft OLE DB Driver 9.0 for SQL 2005, old 8.0 drivers

doesnt work.

 

To install the driver go to this page :

https://www.microsoft.com/downloads/details.aspx?FamilyId=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&DisplayLang=en

 

and choose the appropriate download. Note that the download needs to be installed for every client access machine.