Till now, I used ascmd to execute some queries to SSAS 2008R2. My company begin to install some new SSAS 2012 servers and I want to re-use all my maintenance scripts with these new servers. I can't find any ascmd tool in SQL Server 2012 neither any documents or relatives on the internet.
Does anyone have some information about that? Or a link to download the tool?
When I try to execute a query with my version, i get the following message:
"Microsoft (R) Analysis Services 2008 Command Line Tool Version 10.0.87.5 X86 Copyright (C) 2008 Microsoft Corporation. All Rights Reserved. Ascmd: Exception trying to impersonate user: Could not load file o crosoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, Publi 5dcd8080cc91' or one of its dependencies. The system cannot find t ied. Ascmd: Execution failed: Could not load file or assembly 'Microsof ices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd80 of its dependencies. The system cannot find the file specified."
When I check in C:\Windows\Assembly, I can see that I have the 11.0.0.0 version.
How can I deal with it? I can't use PowerShell script...
Thanks!
You can download the 2008 R2 Analysis Management Objects from this page. That includes the 10.0.0.0 version.