 Hello friends, my name is Susheel Singh and today I am going to discuss how to install SQL Server on your machine. As I have setup of SQL Server 2014, you may have another version of SQL Server but mostly steps are same for the installation. So you have to follow all these steps and you can install SQL Server on your machine. Before going forward, I would recommend if you don't have Microsoft.NET Framework 3.5 Service Pack 1 on your machine, you have to download it and install it first. Otherwise, you will not able to install SQL Server. You have installed Microsoft.NET Framework 3.5 Service Pack 1. You should open your setup and double click on setup exe. Once you have double click, it will open, it will take few seconds. It will open SQL Server installation center. Once you will get SQL Server installation center, then go to the installation. Inside the installation, you have to choose the first option. That is new SQL Server, stand alone, installation or add features to the existing installation. You have to click on it and it will redact to another window. It will take few seconds, you have to wait until it will not be open. Because it will open, then once you will get this screen, you can see there is several steps like product key, license terms, global rules. You have to follow all these steps one by one and on my first, you can see it's a product key. You have a specified product key for your setup. So on my case, I have entered simply click on next. In the second, I have to accept the license term. So I will check on this checkbox and click on next. Then it will check for the global rules. If all these will be okay for our requirement, it will move forward. It will take time in setup files. It's taking time. Yes, installation rule. And inside the installation, you can find out it's showing a warning. The warning is windows firewall. It's windows firewall is not off. So we have to turn off the windows firewall, go to the control panel and go to the windows firewall and then turn off the windows firewall. Once you will turn off the firewall and then go to the setup and click on rerun. It will move forward is set up roles. We don't want to default all features will default. We want SQL Server feature installation. I'll select what feature we want to install. So click on next here. It will ask us what service you want to install database engine service or database reporting services and SQL Server integration services, what type of service you want to install. On my case, I want to install all these services. And then click next, it's taking time here default instance and name instance. If you are going to install for your local machine, you can choose a default instance. If you are going to install for any another machine, you have to choose the name instance. Only one you can install with a single name by default instance. If you want to create one more instance, you have to specify name instance default will be disabled when you are going to install once more. So I'm going to by default then click on next. It's taking time, yes, so it's again taking time, yeah. In server configuration, you have to very take care for the server configuration. Here we can see the setup type. Setup type should be automatic for all these SQL agent, database engine, analysis services, reporting services, integration services, these are the very important part. So we have to set a type should be automatic. Let's rest of the you can choose manual, go to the collision and inside the collision database engine, you have to select our first option, which is sql underscore 1x compact underscore cp850 underscore ci underscore as I'll discuss this later in this video series why we are going to use this database engine collision for this click next here. We want put user ID and password user ID should be essay for system administrator and we want enter some password for the same. So we have to choose the mix mode and enter the password. So I have an interval here and then click on add current user when this user will be added. Click on next. Click on next. Okay. Here in analysis services configuration, you have to choose the add a user. You can use add a user next for the reporting services, you don't need to change anything. You have to simply click on next here. You have to add current user and then click on next in distributed system. If your controller is another from this system, then you have to specify the controller name and user directory. Otherwise, skip this for my case. This is our controller. There is no any controller. So click on next now it's taking time. So it's ready to install. We have to click on install. So you can see there is installation process is going forward. It will take around half an hour. So I'm going to pause and once it will be completed, then I'll show the next. Now you can see SQL Server has been installed successfully. So you can close it and you can open you can search by using SQL Server and it will be open SQL Server Management Studio 2014. Click on it. It's going to take few seconds because it's loading first time. Once it will be loaded, you can log in directly by using window authentication or you can log in by using mix mode as we have specified the password. So you can enter user ID and password. So now it has been successfully completed. I hope now you can understand how to install SQL Server. So thank you so much for watching this video. Please subscribe our channel for many more videos.