Does Microsoft.AnalysisServices.Tabular.NetCore and Analysis services have support for SQL user

Muhammad Pathan 25 Reputation points
2024-02-01T16:06:56.4933333+00:00

I am creating a c# .net 6 azure function app to refresh a data model in azure analysis services. I want to connect to Azure Analysis Services using a connection string using SQL user and password. The docs mention that AAD auth is supported as well as this it supports Windows authentication (integrated authentication) for client application connections. This includes various methods such as NTLM, Kerberos, EffectiveUserName on the connection string however does not mention anything about using sql credentials. I need to and must use sql credentials for this task so need to know and understand if this is possible? The below is what i would be doing for a connection string. The userId is a sql user and the password is the password for this sql user.

// analysis services details
string serverName = "myserver";
string databaseName = "mydb";
string userId = "Sql_userId";
string password = Environment.GetEnvironmentVariable("Sql_PWD");

var connectionString = $"Provider=MSOLAP;Data Source={serverName};Initial Catalog={databaseName};User ID={userId};Password={password};Persist Security Info=True;Impersonation Level=Impersonate;";
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
456 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,087 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,608 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,006 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 45,096 Reputation points
    2024-02-01T19:49:27.6133333+00:00

    however does not mention anything about using sql credentials.

    Analysis Service has it's own authentication system, which has nothing to do with SQL Server engine = SQL credentials. You can't use SQL user/credentials in any way.

    0 comments No comments

0 additional answers

Sort by: Most helpful

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.