Improve connection experience
This is driving me a bit nuts.
I have two machines. One local and a Azure VM with:
SQL Server 2016
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?
Mike Kostuch commented
You can't right now. It only uses AAD identities.