How to Publish an ASP .NET Core 6 Website / APP on a Windows OS and Fix Database Connection Problem

You can watch the video with manually written English subtitles.

I recorded this video upon the request of one of my follower students. His ASP .NET Core 6 Web APP was not working when he published it. However, the app was working fine in development / debug mode.

He was developing his app using #ASP .NET Core version 6 #MVC #CSharp (C#) and MSSQL server express edition.

He has used Migrations to generate his database with code first approach as explained here: https://learn.microsoft.com/en-us/ef/core/managing-schemas/migrations/?tabs=vs

After doing some debugging I found out that his app was not working when published due to database authorization being denied.

In this video, you will learn how to publish and run your ASP .NET Core 3/5/6/7 (any version) app on a Windows Operating system. This OS can be Windows 8, 10, 11, or Windows Server as well.

First, you need to install the IIS server through Turn Windows Features on or off and then install the necessary ASP .NET Core Runtime Hosting Bundle: https://dotnet.microsoft.com/en-us/download/dotnet/6.0

The source of the example application used in this video can be downloaded here: https://github.com/FurkanGozukara/how-to-publish-ASP-.NET-Core-MVC-application

So if your published ASP .NET Core application/website is not working this video will likely solve your problem. Moreover, if you are not sure how to publish your developed app and run it on a remote host or on a local host and emulate it as a remote domain, this video will teach you both.

To solve the database connection problem, we generate a new SQL Server Login account with the necessary permissions. Then we modify SQL connection settings in appsettings.json file. After that when publishing the APP we modify the SQL connection string as well.

Please make comments regarding the video and give me your feedback. You can also ask new questions and I will try my best to answer them.

If you are interested in programming but you don't know where to start, I suggest you watch our playlists in the following order: https://www.youtube.com/c/SECourses/playlists

[1] Introduction to Programming Full Course with C# playlist

[2] Advanced #Programming with C# Full Course Playlist

[3] Object Oriented Programming Full Course with C# playlist

[4] Asp.NET Core V5 - MVC Pattern - Bootstrap V5 - Responsive Web #Programming with C# Full Course Playlist

[5] Artificial Intelligence (AI) and Machine Learning (ML) Full Course with C# Examples playlist

[6] Software Engineering Full Course playlist

[7] Security of Information Systems Full Course playlist

[8] (Turkish) Bilgisayar Becerileri Tam Ders playlist ... https://www.youtube.com/watch?v=9xoIEbVdiZc