locked
Data Explorer not working with the "runas" command

    Question

  • I am connected to a customer's network, but my computer is not joined to their domain. I am trying to use Data Explorer to query one of their SQL Servers.

    All client tools (including Microsoft Query in Excel) are working fine when I execute those applications using the runas command, but Data Explorer does not. I simply get an error:

    "Expression.Error: The evaluation terminated unexpectedly. Details:    at..."

    Does any one know why this is not working?


    Craig Bryden - Please mark correct and/or helpful answers

    Thursday, June 13, 2013 3:55 AM

Answers

  • Hey Craig, 

    We've identified the issue and this is indeed a bug in the product. It'll be fixed as we update our bits.

    Thanks for reporting this!

    Regards,

    PQ


    Peter Q. http://blogs.msdn.com/peter_qian

    Thursday, June 27, 2013 11:55 PM

All replies

  • Excel is the host process for Data Explorer, the core logic runs in a separate process, it's called "Microsoft.Mashup.Container.exe". In theory it should pick up the same privilege as the host process, but just in case, can you try to force elevate that process? You can find it in the install dir\bin\Microsoft.Mashup.Container.exe


    Regards,

    PQ


    Peter Q. http://blogs.msdn.com/peter_qian

    Thursday, June 13, 2013 6:01 AM
  • Hi Peter

    How do I Force elevate the process?

    Thanks


    Craig Bryden - Please mark correct and/or helpful answers

    Thursday, June 13, 2013 6:02 AM
  • Can you try right click the executable file, select compatibility, select change settings for all users, and then check run this program as administrator

    Peter Q. http://blogs.msdn.com/peter_qian

    Thursday, June 13, 2013 10:39 PM
  • Thanks Peter

    How will that get the other executable to "run as" very specific credentials that I have used for Excel?

    Thanks

    Craig


    Craig Bryden - Please mark correct and/or helpful answers

    Tuesday, June 18, 2013 4:05 AM
  • Ah, I see what you mean.

    Unfortunately I'm not quite sure what is going on here, looks like we are getting ACCESS DENIED back when we try to start the container. I'll track this issue internally.

    Regards,

    PQ


    Peter Q. http://blogs.msdn.com/peter_qian

    Wednesday, June 26, 2013 11:08 PM
  • Hey Craig, 

    We've identified the issue and this is indeed a bug in the product. It'll be fixed as we update our bits.

    Thanks for reporting this!

    Regards,

    PQ


    Peter Q. http://blogs.msdn.com/peter_qian

    Thursday, June 27, 2013 11:55 PM
  • Glad to help in any way Peter. Great potential for this product

    Regards,


    Craig Bryden - Please mark correct and/or helpful answers

    Friday, June 28, 2013 12:30 AM
  • Is the BUG now repaired. On my Computer it sill doesn run
    Sunday, June 30, 2013 11:33 AM