"AuthDBContextConnection" appsettings.json connecting to Azure VM SQL
Hi Community I'm trying to create a simple login/registration web app using ASP.NET Core Web App in Visual Studio 2019. I'm having difficulty of connecting to my MS SQL running as IaaS in Azure. In the appsettings.json file, there's a connection string already indicated but the format I'm using isn't working properly. Like to check if this format is correct: "AuthDBContextConnection": "Server=DNSName_Azure;Database=MVCAuthDB;Trusted_Connection=True;MultipleActiveResultSets=true;User ID=username;Password=password" Also, using Packet Manager Console to push the tables/data to the database. Highly appreciate your responses. Note: Tested to connect in VS -> Tools > Connect To Server > and it is working; port 1433 is open NSG