This is an automated archive made by the Lemmit Bot.
The original was posted on /r/azure by /u/psinchuk on 2023-09-01 20:35:56.
Need a little bit of guidance on how to handle SQL in Azure.
We are currently migrating our servers over to VMs or Azure Services when we can and the only ones causing me issues are the SQL Servers. I don't think we are ready to make the jump to Azure Databases so we are trying to go the route of the Azure VM with SQL. The issue I am running into is that the option only allows me to login with local creds and not AAD like the other servers.
How are you all handling this? Do you just use the local admin account and then create induvial accounts for people who need to access the actual DB? I feel like this is a step backwards from what we have now where we can authenticate with our Windows credentials to both the machine and SQL.