I have an application that runs fine locally. ASP.NET CORE, ANGULAR, SQL SERVER DATABASE But, I am having problems when trying to deploy it. I have the SQL Server Database deployed on Azure. The Back end is also deployed on azure. I am running the front end locally to test the back end /database. Any calls that it makes to the database returns a 500 error. I have also tried to use Postman to hit the endpoints, but I also get a 500 error. It didn't give me any errors when I published it and it showed that it should run. When I publish the solution it shows the database is connected. You can see from the screen print that I have connected application insights also but it hasn't given me much information. This is in Azure showing where the error was thrown, but I don't know where this is in my code: These are the calls that get a 500 error they are both making calls to the db Here is the inspect from the locally running front end: I followed this tutorial to deploy but I am not sure that the information it gave to connect the database to my API applied to the Stack I am using. https://www.youtube.com/watch?v=u_CRppLcC9k&t=463s Thank you in advance for any direction or help you can give me. I have been stuck on this for about a week. Continue reading...
