Improve connection experience
This is driving me a bit nuts.
I have two machines. One local and a Azure VM with:
SQL Server 2016
SSAS Tabular
and
Azure SQL database.
My employer doesn't have any Azure Active directory services.
I've created an AAS server and can connect to it with ssms.
When I try to deploy I get error messages, but somehow the metadata for both database sources has been deployed but it cant process.
It keeps insisting that the impersonation settings are invalid but I can only use windows authentication to access the vm in azure.
At first I forgot to add a role. If so it would be nice to have Visual Studio refuse to deploy and give me an error message "hey dummy you forgot to add a role/members. This may be a case of user error but a nudge in the right direction would be appreciated.
Next step, how do I add members if we don't use Azure Active Directory?
daniel
shared this idea
1 comment
-
Mike Kostuch
commented
You can't right now. It only uses AAD identities.