How to publish ASP.Net MVC 5 with SQL database to IIS

[Applause] [Music] [Applause] [Music] in this video we are going to publish the asp.net application along with the max of SQL Server database on the localhost so for publish make sure guys your application is working fine in the region studio if your ramen an execute the application you should work properly in your browser with ask yourself if it is working fine here then you can publish it on the localhost or running that server or you can say for I mean hosting so let me show you my application is working on with my ask your first application so and it's logged so after the login I'm going to brought something to show you in class my application is working fine so guys first make sure your application is working on the media to do what you do best next thing on the main folder in the main directory of that application just right click and find out the publish option if you click on this option provide us some more options from here you can publish directly to your FTP account to your web server or on your local machine so I'm going to select the custom and from here I'm going to you can say name the folder where I'm going to publish my application on my local machine so customers used to publish the application so I'm going to give it name after this it is going to ask on which method you are going to publish you have to multiply F TV directly to your server file manager or file system so I'm going to select the file system which is which asked me for the third row munication means the folder you want publish files so I'm going to browse it My Documents I'm going to create a new folder for this so I'm going to minimize XD publish it's going to ask you that your are you sure you want to clear this folder okay this is just before after reading the folder I'm going to click the next so here you got some options you can it's like a release because I'm running my please assure you of the debugging so oil slick the renée's and there's a few folders if you are published your application second time or multiple times you can select and delete all existing files go to the publish which means in the selected target vacation folder if the published version is already exist you can replace or you can replace the lettuce fast with it so I'm going to this is first time I'm going to publish this application and if you have your database locally in your application folder AppData folder you can see here you can select to execute if you want to execute database from your application so I'm going to find next okay it showed me the directory where it's going to publish my files after I click publish it so click on publish if you guys have any error or bug in your application let me just you just going to show you so I've just one succeeded zero fed that's been my application is probably successfully and it showed me the directly in your I published so I got in my documents and they're texting are published extinct on this folder so this is my application which I published so next thing you need guys you guys need to have you open your Internet Information Services so here's mine so first make sure your published version have a permission so for giving the permission to disorder just go to the properties you can add from security from a security and click on added and I'm going to find the name everyone saw on my machine everyone can access this folders so I'm going to get access okay okay so next thing to scorpions folder go to your C Drive to the main directory of the Internet Information Services which is undeveloped you do it here I'm going to paste my folder okay and just information continue so offer place your folder here and giving you permission to this folder I'm going to Internet Information Services the default I found out my folder so you can say it this is just a folder it is another published version so I click on the right right-click I'm going to convert it to application ok it will say your foreign name is this and you are going to reduce your default app and the physical possibilities means host after punished for name okay now your application is published properly you speak on the browse so you can see now after the browsing I go to localhost here and doctor I'm I had my folder name okay so you can see guys my application is working on my published localhost so let me try that is the application is working with our service console probably you're not it's right click on the login my name okay fine when I click on the sign in show me this exception so don't worry here just follow the instructions so it is saying your daughter your the login is fair due to your database have the requested but a login is open so this we need to copy this exception here just copy it and go to your much suppress here finally categories my database so in the database is just go to the security folder the security folder go to the users right click on it and add a new user so after click on add a new user I'm going to paste the name which I find out on the browser such names piece here and my hair we are going to select that this user is going to be other this database so it can access all properties to it so from all schemas you can collect inspect Conner and membership click on from this three stages we have to select the owner for this user thank you ok refresh database negation I'm going to think and submit my information in the info so here we go go to login we can complete access to published web application so I'm getting wrong card I'm getting the list of users that's all so these are the few steps guys we have to follow when you publish you need to walk across and if you publish on the server maybe you get some kind of another exception and the attenti kitchenette for something just copy that thing and go to Ostia just add a nice quixote a new user and allow this to be the database on earth so this is going to allow you the access the communication between your application and magnus SQL server I hope so this video is useful for you guys if some commands subscribe my channel [Music] [Applause] [Music]

Channel: XD Developers

Views: 50,847

Keywords: MVC, C#, Database, SQL, Publish, MVC5, IIS, Programming, Coding

Id: vM5VlBFfNNc

Length: 9min 20sec (560 seconds)

Published: Sun Jul 22 2018