This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
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
}
}
]
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)
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?
"AuthenticationKind": "UsernamePassword"
Try it with
"AuthenticationKind": "Windows"
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.
![](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)
@Pieboy Could you please try to force the connection to always use gateway on AAS by following the below steps -
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.
This error indicates you need to have On-Premise Gateway installed on your local machine, which is a prerequisite of SaurabhSharma suggestion.
@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