Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

ConnectionString for remote server while Referring Accelerator as a DLL

Suresh 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>>”;

4 answers

Dmytro Zvazhii Flexmonster February 27, 2018

Hello Suresh,
Thank you for writing. Please find more information about setting connection string for accelerator here –
Let us know if it was helpful for you.

Suresh February 27, 2018

Hello Dmytro,
I don’t want to use ‘../msmdpump.dll’ url. Will it work like this ?
CONNECTION_STRING=Data Source=;UID=Test;Password=Password;

Tanya Gryshko Tanya Gryshko Flexmonster 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.

Suresh 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.

Please login or Register to Submit Answer