Share via

How do I ensure Analysis Services version 2019 client TCP connectivity is encrypted?

Turcas, Elian 0 Reputation points
2023-01-23T23:13:41.0466667+00:00

Our customers connect from Excel to SSAS (versions: 2016, 2019) with a connection similar to: "Provider=MSOLAP.8;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=NWS;Data Source=.;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Update Isolation Level=2"

Our customers want their data traveling from SSAS to Excel over TCP, to be encrypted. Please provide guidance/relevant steps

(I tried to reconcile this link with parameters in my msmsrv.ini (see attached); however DataProtection\RequiredProtectionLevel is missing from msmsrv.ini)

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,310 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,571 Reputation points
    2023-01-25T09:12:33.61+00:00

    Hi Turcas, Elian,

    Please refer to this link: Configure in msmdsrv.ini
    In addition, here is a related thread: Extra security on Excel OLAP Reporting from SSAS cube

    Best regards,

    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.