Azure SQL Database
An Azure relational database service.
5,731 questions
"AuthenticationKind": "UsernamePassword"
Try it with
"AuthenticationKind": "Windows"
Azure Analysis Services: Not able to connect to data source(SQL server) with Active directory(In Model.bim)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 79%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Pieboy
1
Reputation point
In credential section of Model.bim we define the way we are going to authenticate the data source(here SQL server) , right now i'm using DB user, DB password with AuthenticationKind="UsernamePassword" and it is working fine and able to refresh models successfully. But now i want to authenticate the SQL server with Active directory instead of DB user and DB password. Can anyone help what should be AuthenticationKind for this? I tried using AuthenticationKind as "UsernamePassword" and "Windows" but it is not working.
Here is a sample dataSource part of Model.bim
"dataSources": [
{
"type": "structured",
"name": "SQL/sampsledb database windows net;sampsledb",
"connectionDetails": {
"protocol": "tds",
"address": {
"server": "sampsledb.database.windows.net",
"database": "sampsledb"
},
"authentication": null,
"query": null
},
"credential": {
"AuthenticationKind": "UsernamePassword",
"kind": "SQL",
"path": "sampsledb.database.windows.net;sampsledb",
"Username": "SampleUser",
"EncryptConnection": true
}
}
]
{count} votes
-
Pieboy 1 Reputation point
2021-01-04T05:49:02.533+00:00 But i'm trying to connect Azure analysis service with SQL server in Azure(data source), Do we need On-Prem gateway for that?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT 5,821 Reputation points2021-01-05T08:28:03.897+00:00 So, to make the scene clear here :
Are you trying to connect to Azure SQL Database with Azure Active Directory ?
Or are you talking about SQL Server in Azure VM with Active Directory on VM?
Sign in to comment
2 answers
Sort by: Most helpful
-
Olaf Helper 44,941 Reputation points2020-12-30T12:22:31.027+00:00 -
Pieboy 1 Reputation point
2020-12-30T12:29:09.637+00:00 Hi,
Already tried this and got this error while refreshing: Failed to save modifications to the server. Error returned: 'Windows authentication has been disabled in the current context.. The exception was raised by the IDbCommand interface.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,816 Reputation points Microsoft Employee2020-12-30T19:50:07.523+00:00 @Pieboy Could you please try to force the connection to always use gateway on AAS by following the below steps -
- Connect Management Server Name (which end with :rw) of AAS with SSMS.
- Right click server name and choose Properties.
Modify ASPaaS\AlwaysUserGateway to true
- Restart AAS server and try to process again.
-
Pieboy 1 Reputation point
2020-12-30T20:12:48.97+00:00 Hi, I followed all the steps and now i'm getting this error: Failed to save modifications to the server. Error returned: 'On-Premise Gateway is required to access the data source. Please install a unified gateway for the server {db server} or disable AlwaysUseGateway setting if it's enabled.
-
Lukas Yu -MSFT 5,821 Reputation points
2021-01-04T02:58:49.02+00:00 This error indicates you need to have On-Premise Gateway installed on your local machine, which is a prerequisite of SaurabhSharma suggestion.
-
Saurabh Sharma 23,816 Reputation points Microsoft Employee
2021-01-07T15:45:31.807+00:00 @Pieboy Following up to know if you are unblocked. If so, please accept the answer as this will help other community members facing similar query to refer to this solution. Thanks
Sign in to comment