asked on February 27, 2018
What is connection string for remote MSAS server while Referring Accelerator as a DLL using Username and Password ?
Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.ConnectionString = "Data Source=<<remote_host>>";
⋅ February 27, 2018
Hello Suresh,
Thank you for writing. Please find more information about setting connection string for accelerator here - https://www.flexmonster.com/doc/configuring-authentication-process/.
Let us know if it was helpful for you.
Regards,
Dmytro.
⋅ February 27, 2018
Hello Dmytro,
I don't want to use '../msmdpump.dll' url. Will it work like this ?
CONNECTION_STRING=Data Source=10.7.4.70;UID=Test;Password=Password;
Thanks.
⋅ March 1, 2018
Hello, Suresh,
If Accelerator and cube are located on the same local network, you can connect without using msmdpump.dll or providing credentials. The only requirement is that your current Windows user should have access permissions for database and cube.
If your cube is on another server, configuring HTTP access to Analysis Services is a necessary step. This would require msmdpump.dll configuration.
Please let me know in case of other questions.
Regards,
Tanya
⋅ March 1, 2018
Thanks Tanya for your answer. Accelerator and Cube are in same network. So now I am able to connect cube from Accelerator. Just added network user to Accelerator Services.
Thanks,
Suresh.
