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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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;";
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.