Here is a very simple scenario:
a asp.net application retrieves data from remote SSAS 2008R2 CUBE.
string conString = "Data Source=10.1.1.5;Catalog=Adventure Works DW 2008;";
AdomdConnection con = new AdomdConnection(conString);
AdomdCommand command = new AdomdCommand("select from [Adventure Works_1]");
AdomdDataAdapter da = new AdomdDataAdapter("select from [Adventure Works_1]",con );
DataTable dt = new DataTable();
I already set:
1. localservice, anonymous, network service accounts in both SSAS Instance Security and SSAS DB roles.
2. RequireClientAuthentication = false.
unfortunately, I always got the following message:
"An existing connection was forcibly closed by the remote host"
Should I set up HTTP access for SSAS? and why?
Thank you very much for your kind help!!!
View Complete Post