Last post Sep 21, 2012 08:29 AM by alendonold
Sep 11, 2012 02:50 AM|alendonold|LINK
I am trying to connect with analysis services (SSAS) using VS2005 code behind with Microsoft.AnalysisServices.Xmla.XmlaClient.Connect(server name/IP) and its working if both web server and sql server are in same machine, but when
I am trying to access remote server to connect with AS its giving me "A connection cannot be made. Ensure that the server is running.". I think its because SSAS only works with windows authentication. My requirement is to connect with SSAS and after that
create new SSAS DB using XMLA script also I have to process the ASDB. Does anyone have any thoughts on this?
Sep 18, 2012 04:25 AM|Dino He - MSFT|LINK
To connect and use analysis services with remote location,
creating users with the same name and password in different domains is suggested.
Hope be helpful!
Sep 21, 2012 08:29 AM|alendonold|LINK
Thanks Dino for your Answer. I appriciate your time:-)