I have two separate servers one running SQL 2008 R2, the other running the associated Analysis Services connected to the SQL server, in the same domain.
If I run ascmd.exe on the SQL box or the Analysis Services box specifying the server etc. then it will connect and process the XMLA script successfully. However, if I run the same object with the same options on other systems then they end in error with:
>> An error occurred during processing: A connection cannot be made. Ensure that the server is running.
Given that the SQL box can connect, what needs to be setup and configured to enable a connection from a box where SQL and Analysis Services has not been loaded? What is needed to allow the Analysis Services objects to connect? Are there any logs to determine where the connection is being rejected?
Thanks.