While using SQL Server 2008 R2, I was able to execute ASCMD SSAS queries. We recently upgraded to SSAS 2012 servers and I hope to reinstall all my maintenance scripts. I can't find any ASCMD tools in SQL Server 2012, nor any documents on the internet.
When I try to execute a query I get the following error 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:WindowsAssembly, I can see that I have the 18.104.22.168 version.
Are there any tools I can use? I can't use PowerShell script...
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!