CODEWITHSUNDEEP
windowsasp.net-coreubuntussas
Majid Ramezankhani
Majid Ramezankhani

Reputation: 148

connect to SSAS (SQL Server Analysis Services) from ubuntu

I have an ASP.NET Core(.net 5) application that is currently running on a Windows server and I am connecting to SSAS through Microsoft.AnalysisServices.Tabular and the following information:

{
    "SSASDataSource": "Provider=SQLNCLI11;Data Source=localhost;Initial Catalog=MyDB;Integrated Security=SSPI;Persist Security Info=false",
    "SSASDataSource_UserName": "windows_username",
    "SSASDataSource_Password": "windows_password",
}

You can only connect to SSAS through Windows authentication.

I want to move my app to an ubuntu server.

But I don't know how to connect to SSAS from within ubuntu using Windows authentication

Or is it possible to do this at all?

Upvotes: 0

Views: 971

Answers (1)

Brenton
Brenton

Reputation: 444

This is possible if SSAS is configured for HTTP access.

See the Basic Authentication and Anonymous User section in the documentation for Authentication methodologies supported by Analysis Services for more information. If you configure HTTP access, you can then specify the username and password in the connection string with User ID=...; Password=....

Upvotes: 2

Related Questions