Share via

Connecting to MS SSAS without using Windows Authentication

Tandon, A. (Abhyudaya) 1 Reputation point
2022-09-19T12:56:46.363+00:00

Is there a way to connect to MS SSAS without using Windows Authentication ?

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,276 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 32,026 Reputation points MVP
    2022-09-19T18:32:41.673+00:00
    0 comments
  2. Joyzhao-MSFT 15,576 Reputation points
    2022-09-20T03:00:30.49+00:00

    Hi @Tandon, A. (Abhyudaya) ,
    Connections from a client application to an Analysis Services instance require Windows authentication (integrated).
    The Analysis Services client libraries only work with Windows security principals.
    See more: Authentication methodologies supported by Analysis Services.
    Best Regards,
    Joy

    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".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  3. Olaf Helper 44,296 Reputation points
    2022-09-21T06:02:34.273+00:00

    By default SSAS supports only Windows Authentication.

    The only other way is to setup and using HTTP access, see
    Configure HTTP Access to Analysis Services on IIS 8.0

    0 comments

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.