ConnectionString for remote server while Referring Accelerator as a DLL

posted on February 27th, 2018

Answered

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

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-authentication-process/.
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.

ConnectionString for remote server while Referring Accelerator as a DLL

4 answers

Please login or Register to Submit Answer