ascmd for SQL Server 2012
-
Thursday, February 14, 2013 3:01 PM
Hi everyone!
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!
All Replies
-
Thursday, February 14, 2013 4:18 PM
We now use powershell. The ascmd is included there.
In the powershell there is an invoke-ascmd.
There is a nice tutorial here:
MVP MCT MCTS Daniel Calbimonte
http://elpaladintecnologico.blogspot.com- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 4:20 AM
-
Friday, February 15, 2013 8:32 AM
That's what I read till now but I can't use PowerShell :(
-My company blocked the "UnRestricted" execution policy (second step of the tutorial you gave me)...
-If I can't access this mode, I don't think it will be possible :/, that means I need to re-write a lot of scripts to avoid multiple versions of scripts which do the same thing in a different way. Waste of time and money..I hate when some working tools change or just disappear...
-
Wednesday, February 20, 2013 8:43 AMModerator
Hi el_grom,
We use Invoke-ASCmd cmdlet to execute queries or scripts that are contained in input files in SSAS 2012. For more information, please see:
Invoke-ASCmd cmdlet: http://technet.microsoft.com/en-us/library/hh479579.aspxThanks for your understanding.
Regards,
Elvis Long
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 4:20 AM
.png)
