none
ascmd for SQL Server 2012

    Question

  • 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!

    Thursday, February 14, 2013 3:01 PM

Answers

All replies