Search This Blog

Friday, November 7, 2008

SQLDMO cannot connect to Anaysis Services version 10.0.1600.22

Get error cannot connect to Anaysis Services version 10.0.1600.22 when trying to connect to SQL analysis server 2008

Found this posting Need AMO update:

The C# application was written for SSAS 2005 and thus references the 2005 version of Microsoft.AnalysisServices.dll (AMO). The 2008 version of AMO was just released at this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

Scroll down to "Microsoft Analysis Management Objects" and install. The 2008 version of AMO will install to ...\Program Files\Microsoft SQL Server\100\SDK\Assemblies. In the C# solution, remove the reference to the 2005 version of this DLL and replace it with the 2008 version. BTW, this should open both 2005 and 2008 cubes.

No comments: