can`t add a reference Microsoft.AnalysisServices

Question

_{Saturday, March 19, 2016 6:32 PM}

My greetings to developers. I have a problem: can`t add a reference Microsoft.AnalysisServices.dll in Visual studio 2013 ultimate 12.0.31101.00 update 4  I have sql server 2014  RTM 12.0.2000.8.  enterprise. The version of dll is same as sql server- 12.0.0.0.8 The path to .dll is C:\Windows\assembly\GAC_MSIL\Microsoft.AnalysisServices\12.0.0.0__89845dcd8080cc91\Microsoft.AnalysisServices.dll.

I tried also another version of dll  10.0.25.31.0. but unfortunately it didn't help.  to my desperate tryings I have an idea to install another( previous) version of sql server(12)

All replies (6)

_{Saturday, March 19, 2016 11:06 PM}

Hi Konstantin_Dev,

You can try with nuget package manager, type this command in console:

install-package Microsoft.AnalysisServices.AdomdClient

And here is similiar MSDN forum thread: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8f5c92fb-c287-4d93-9dde-7f1b17ac0896/references-for-using-microsoftanalysisservices-and-microsoftanalysisservicesadomdclient?forum=sqlanalysisservices

Best regards!

(If this was helpful for you, vote for it and propose it as an answer)

_{Monday, March 21, 2016 9:13 AM | 1 vote}

Hi Konstantin_Dev,

In SSAS, to reference "Microsoft.AnalysisServices.dll", you need to add the Analysis Management Objects(AMO) as reference. I tested in my local environment (SQL Server 2014 + SSDT for VS 2013), it works properly.

Regards,

Simon Hou
TechNet Community Support

_{Monday, March 21, 2016 7:40 PM}

Thank you, Simon.

But to add the  reference I should know where the dll of AMO is located. I have installed already Microsoft SQL Server 2014 Analyses Management Objects. Could you kindly write location of this dll?

_{Tuesday, March 22, 2016 9:28 AM}

But to add the  reference I should know where the dll of AMO is located.

It's located in GAC, you only need to add a references as in Simon's screenshot.

Olaf Helper

[ Blog] [ Xing] [ MVP]

_{Saturday, March 26, 2016 9:44 AM}

I added a reference to Microsoft Analysis Objects, but it didn't work out. Still classes  such as   Server, Database,etc are  not available. It is seen on the picture. And the  reference  to AMO is not saved in the reference list.

_{Thursday, October 4, 2018 11:49 PM}

Thanks This helped

Thanks Shiven:) If Answer is Helpful, Please Vote