ConnectionString for remote server while Referring Accelerator as a DLL

Answered

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

Public
Dmytro Zvazhii Flexmonster 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-usernamepassword-protection/.
Let us know if it was helpful for you.
Regards,
Dmytro.

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

Public
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.
Regards,
Tanya

Public
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.
 
Thanks,
Suresh.

Please login or Register to Submit Answer