ascmd for SQL Server 2012


  • 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 X86
    Copyright (C) 2008 Microsoft Corporation.  All Rights Reserved.
    Ascmd: Exception trying to impersonate user: Could not load file o
    crosoft.AnalysisServices, Version=, Culture=neutral, Publi
    5dcd8080cc91' or one of its dependencies. The system cannot find t
    Ascmd: Execution failed: Could not load file or assembly 'Microsof
    ices, Version=, 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 version.

    How can I deal with it? I can't use PowerShell script...


    Thursday, February 14, 2013 3:01 PM


All replies