Wow! After going through numerous videos, none of them provided such clear and comprehensive step-by-step instructions. I'm thrilled to say that it's finally working! Thank you so much for your invaluable help!
I needed to figure out how to do this and my dad said it took him like 3 days to do this! I did it in about 4 hours including yesterday and today morning (and i'm only 13) thanks to this video. Thank you so much!
@@HaribabuPasupathyhi, I got the same error, and I figured out the reason, that is 'couldn't connect to the connection string', so I modified the ConnectionString in appsettings.json, and in my case, I did like this: "DefaultConnection": "Server=xxxx;Database=xxxx;User Id=xxxx;password=xxxx;Trusted_Connection=False;TrustServerCertificate=True;Encrypt=False" And I edited '.NET CRL version' in Application Pool to 'No Managed Code'
Thank you appreciate it, this does help. My only issue is now, I have a DB connection and I get 500's due to that, I will figure it out, I know I am hitting it because I put in a route with no DB and it works. I appreciate you doing, might I advise you make a video showing it with a more mature controller one that is hitting a DB etc, if not I will try to make that video. VERY HELPFUL
Great Video. But how to get options like "User This Connection String at run time" and "Entity Framework Options" as these options are available in Publishing Local Folder
@@intcoder I m working on code first approach. During development, if I change any model then I can execute commands for add-migration and then update-database. But after publishing web api, I have to execute same command on production environment. With IIS deployment I am not able to find way to update production database. I am new in .net core. Currently using .Net6, entity framework and MySQL. I need complete steps for publishing and updating remote production server and database.
how can i solve this error API Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot get a local application data path. Most probably a user profile is not loaded. If LocalDB is executed under IIS, make sure that profile loading is enabled for the current user. )
I'm able to publish the folder file, but every time I Selecta webdeploy on iis it puts up a error message saying that there is a problem inside the temp folder. More specifically the tmp88EF.tmp
I got the same error, and had to modify the Web Deploy install to fix it, because the Typical install didn't install the Remote Agent Service. I fixed it by choosing Add Remove Programs->Microsoft Web Deploy 4.0->Modify and installed the Remove Agent Service.
It would be useful if you tell us the contents of the web.config as generated by the Wizard, I am publishing manually (no VS wizard) and it doesn't work (404 !), therefore I think I need a web.config of some sort ? but I am not sure.
@@intcoder yes exactly, I figured out why it didn't work, the default folder path set by the Wizard is "bin\Release et5.0\publish\", and I was moving the whole Release folder into my IIS server, when I should have moved only the "publish" folder!. But after seeing your video that there was a web.config file, it made me look deeper into it, thanks!
Sir, you have shown to publish the app that doesn't have any database. Would you please share how to do it when an application has a database. By default, vs doesn't include database file for asp.net core project the way it used to save in App_Data folder in case of asp.net MVC project. Please share in which directory database file get saved after published to iis.
Thanks for the video, but when I publish all I get is a web.config file (not using default demo weatherforecast, but EF to a SQL server database, which works fine directly of VS2022). Any ideas why none of the other DLL files were "published"?
if you are not able to access the EF/SQL database, make sure you are including user name and password on your connection string. Do not use "Integrated Security" when deploying to IIS.
Weather forecast controller is running but my controller which my project is based is not working, it is giving me page not found error. Can you tell me what to do? Thank you.
@@intcoder I watched your video, but it doesn't mention publishing. I have a .Net 6 CORE Razor app which I've already reverse-engineered the classes from the tables. I have gone into the publish profile, and have added the database connection string and the entity framework migration. I'm breaking my number one rule by asking a follow on question, but your video is the only one I can find where the author seems to know what he's talking about. Any ideas?
Swagger is usually used for testing purpose. However, if you go to program.cs there is a configuration that only loads Swagger on development. You can turn that off.
Hi, It works for me only if my application has no localDB data. When the published WebApp needs to access some stored data in localDB it is not working. How to fix that? I've tried a lot of solutions but all without success.
Very good tutorial! I followed your instructions to the letter, and everything seems to be setup correctly. All the files are in the correct directory, and I added my project name to the end of the URL. But, when I try to run it, either from IIS or from the browser. I get: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid. Error Code: 0x80070003 I've googled the error, and it says that it is due to a lack of permission or the web.config is missing. The web.config is there, and I am an administrator for the directory I published to. Any ideas?
@@intcoder I found the problem. I was publishing to a folder on my server, and apparently I don't have the correct permissions to access the website. I tried it by publishing to a drive on my local computer, and it worked. Again, great tutorial!!!!
Why you lie to people, its deploing, not publishing, i look 10 videos like this, do all steps and get only local access, U must say about ports on router first, site not accesible from external before open ports
The video teaches you to publish to IIS not to open ports, as is stated at the start of the video. One can publish it to development/staging without opening external ports.
@@intcoder Why, its name publish? If it can access only I?What difference from deploy? I want run api on computer and access it, at least from phone in same wifi, to test update xamarin app from api, but look 10 videos, and get only access from computer, that i can do when run in vs 2022
@@intcoder I understand that blogers think deploy and publish the same, and look other things, i found ngrok, but for free it take only random ip, for update i maybe need the same ip, for app can find it by check update, now I looking access to api in local network
If you need to Access your Web API from inside and outside network here is the tutorial:
th-cam.com/video/AaRc8048HB0/w-d-xo.html
Wow! After going through numerous videos, none of them provided such clear and comprehensive step-by-step instructions. I'm thrilled to say that it's finally working! Thank you so much for your invaluable help!
This video is PERFECT. Very easy to follow and no extra crap. Thank you - my little test API is working perfectly.
wow, I ve been battling with this issue for 5 hours now. so all i needed to do was /WeatherForecast.
Thanks alot boss
Thanks! Haven't done a side project since DOT NET 3! Got my site working locally with Angualr and DOT NET 6! 👍🏽
Thank you so much for this video. I was spending more that 2 hrs and finally it helped me.
The video was super easy to follow - I got my API published within minutes after watching it.
Thanks for sharing this!
Glad it helped!
I needed to figure out how to do this and my dad said it took him like 3 days to do this! I did it in about 4 hours including yesterday and today morning (and i'm only 13) thanks to this video. Thank you so much!
That is awesome!
I get HTTP Error 500.19 - Internal Server Error when trying to launch, please someone can help me ?
same here! any solution?
@@HaribabuPasupathyhi, I got the same error, and I figured out the reason, that is 'couldn't connect to the connection string', so I modified the ConnectionString in appsettings.json, and in my case, I did like this:
"DefaultConnection": "Server=xxxx;Database=xxxx;User Id=xxxx;password=xxxx;Trusted_Connection=False;TrustServerCertificate=True;Encrypt=False"
And I edited '.NET CRL version' in Application Pool to 'No Managed Code'
thank you that was pretty straight forward and clear! good work keep it up.
Glad I could help!
Thank you appreciate it, this does help. My only issue is now, I have a DB connection and I get 500's due to that, I will figure it out, I know I am hitting it because I put in a route with no DB and it works. I appreciate you doing, might I advise you make a video showing it with a more mature controller one that is hitting a DB etc, if not I will try to make that video. VERY HELPFUL
HTTP Error 500.19 - Internal Server Error
When I go to Weatherforecast, how do I fix this?
did you find solution?
I get same error.
me too
You saved an already frustrated developer with that last bit on testing published site.
How can i publish it to a webhost ?
Great video. Helped me so much! Thank you!
Glad it helped!
Thank you !! Video was spot on and works fine.
thank you so much! it was very helpful :)
Great Video. But how to get options like "User This Connection String at run time" and "Entity Framework Options" as these options are available in Publishing Local Folder
Like production and development connection string?
@@intcoder I m working on code first approach. During development, if I change any model then I can execute commands for add-migration and then update-database.
But after publishing web api, I have to execute same command on production environment. With IIS deployment I am not able to find way to update production database.
I am new in .net core. Currently using .Net6, entity framework and MySQL. I need complete steps for publishing and updating remote production server and database.
@@AmitVerma80 @Amit Verma you need to make sure to update your db connection
string when updating production.
how can i solve this error
API Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot get a local application data path. Most probably a user profile is not loaded. If LocalDB is executed under IIS, make sure that profile loading is enabled for the current user.
)
I'm able to publish the folder file, but every time I Selecta webdeploy on iis it puts up a error message saying that there is a problem inside the temp folder. More specifically the tmp88EF.tmp
I got the same error, and had to modify the Web Deploy install to fix it, because the Typical install didn't install the Remote Agent Service. I fixed it by choosing Add Remove Programs->Microsoft Web Deploy 4.0->Modify and installed the Remove Agent Service.
While deploy application ,connect with sql Db is it necessary to is id and pwd..we cannot use windows authentication mode ??
That’s correct. You have to set sql login and password. Windows authentication only works while testing locally
after publishing my console is not opend i want my cosole open so that i can check logs
How do you make it HTTPS and publish it as public for the world to use?
First pined comment has another link.
@@intcoder Thanks! I must be blind or something :)
when i publish my website does is publish my sql server database with it?
i got the Error 500.19 whenever i try to launch , do u have any clue bout it
Me also
me too
It would be useful if you tell us the contents of the web.config as generated by the Wizard, I am publishing manually (no VS wizard) and it doesn't work (404 !), therefore I think I need a web.config of some sort ? but I am not sure.
When you say that you are manually publishing. What are you doing? Are you publishing to a local folder and copying it?
@@intcoder yes exactly, I figured out why it didn't work, the default folder path set by the Wizard is "bin\Release
et5.0\publish\", and I was moving the whole Release folder into my IIS server, when I should have moved only the "publish" folder!. But after seeing your video that there was a web.config file, it made me look deeper into it, thanks!
@@joe-sydney-au Glad i could help!
Sir, you have shown to publish the app that doesn't have any database. Would you please share how to do it when an application has a database. By default, vs doesn't include database file for asp.net core project the way it used to save in App_Data folder in case of asp.net MVC project. Please share in which directory database file get saved after published to iis.
Have you tried entity framework? you can query the database with it.
@@intcoder yes
Thanks for the video, but when I publish all I get is a web.config file (not using default demo weatherforecast, but EF to a SQL server database, which works fine directly of VS2022). Any ideas why none of the other DLL files were "published"?
if you are not able to access the EF/SQL database, make sure you are including user name and password on your connection string. Do not use "Integrated Security" when deploying to IIS.
@@intcoder the issue seems to be a bug in Publisher profiles. I've recreated my IIS profile and it worked from there. Thanks anyway
@@LatinoTropico Thanks for the feedback.
transfer-encoding: chunked getting this error
pls tell how i can resolve this problem
Weather forecast controller is running but my controller which my project is based is not working, it is giving me page not found error. Can you tell me what to do? Thank you.
Did you solve your problem ? I have same problem.
Do you have a tutorial that shows publishing an app that connects to a database?
What database type ?
@@ericianino SQL Server 2019
@@bhames50 i have a tutorial using entity framework.
th-cam.com/video/pVwBnt3idps/w-d-xo.html
@@intcoder I watched your video, but it doesn't mention publishing. I have a .Net 6 CORE Razor app which I've already reverse-engineered the classes from the tables. I have gone into the publish profile, and have added the database connection string and the entity framework migration. I'm breaking my number one rule by asking a follow on question, but your video is the only one I can find where the author seems to know what he's talking about. Any ideas?
No need to add to system32/drivers/host file?
All i needed to do was to install the .net Framework.
Thanks for sharing this!
My pleasure!
Ok, but what about swagger? It would be nice to work too...
Swagger is usually used for testing purpose. However, if you go to program.cs there is a configuration that only loads Swagger on development. You can turn that off.
Hi, It works for me only if my application has no localDB data. When the published WebApp needs to access some stored data in localDB it is not working. How to fix that? I've tried a lot of solutions but all without success.
when publishing to IIS, make sure you database user permissions is not your Active Directive account. Make sure is you create an actual database user.
If publishing to a domain not local host.
perfect help😁
Very good tutorial! I followed your instructions to the letter, and everything seems to be setup correctly. All the files are in the correct directory, and I added my project name to the end of the URL. But, when I try to run it, either from IIS or from the browser. I get: HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid. Error Code: 0x80070003 I've googled the error, and it says that it is due to a lack of permission or the web.config is missing. The web.config is there, and I am an administrator for the directory I published to. Any ideas?
are you able to publish a non Core application to IIS?
@@intcoder I found the problem. I was publishing to a folder on my server, and apparently I don't have the correct permissions to access the website. I tried it by publishing to a drive on my local computer, and it worked. Again, great tutorial!!!!
what if we have multiple controllers?
Same process. You just use a different URL to query a different controller.
@@intcoder does not work! i am still getting 404 error
Should choose ‘file’ when publishing.
THANK YOU!!!!!!
Thank u very much
thank you so much
top
thx
Te amo
Why you lie to people, its deploing, not publishing, i look 10 videos like this, do all steps and get only local access, U must say about ports on router first, site not accesible from external before open ports
The video teaches you to publish to IIS not to open ports, as is stated at the start of the video. One can publish it to development/staging without opening external ports.
@@intcoder Why, its name publish? If it can access only I?What difference from deploy? I want run api on computer and access it, at least from phone in same wifi, to test update xamarin app from api, but look 10 videos, and get only access from computer, that i can do when run in vs 2022
@@intcoder I understand that blogers think deploy and publish the same, and look other things, i found ngrok, but for free it take only random ip, for update i maybe need the same ip, for app can find it by check update, now I looking access to api in local network