MS SQL Server Installation | How to Install SQL Server | Install SQL Server 2017 | Intellipaat
Articles,  Blog

MS SQL Server Installation | How to Install SQL Server | Install SQL Server 2017 | Intellipaat


Hey guys welcome back to this SQL
tutorial course. So in this session we’ll be installing Microsoft SQL server. So
all you have to do is go to Google and then type Microsoft SQL server
download and you’ll get these search results, now all of these search results
click this one where you see SQL server downloads from the Microsoft site
so we are into the site now if I scroll down we see two free editions we have
the developer edition and the Express Edition, so I’d be downloading the
developer edition I click on download and the download will start
now this is the downloaded file over here SQL server 2017 SSCI development
so we get this window here and we have three options basic, custom and download media. So I click on custom now we see that we have a media location where
the SQL server will be downloaded and I’ll click on install you see that the download is successful
and our installation will begin shortly here I’ll click on installation and I’ll
select this one so I’ll be installing a standalone installation of the SQL
server so let us wait for this to open all right so here I click on next
now I only have one instance of SQL server so I’ll be installing a new one
so I lL select this perform a new installation of SQL server 2017
and then I’ll select this free edition and click on next after that I’ll accept
this license agreement and again I’ll click on next
so we have all of these features over here so I would just need the database
engine services so I’ll select this and again I’ll click on next so I have to name the instance for the
server which I’m installing so I ll name this server as let’s say sparta
similarly I will give the same instance id over here, I’ll click on next so again I’ll click on next over here
so we see that we have two authentication modes, windows authentication mode and mix mode. I will select the mixed mode and then enter the desired password let
me put in my password over here I ll add the current user so the current user has been added. Now
I’ll click on next again right so you’re finally ready to install
SQL server. I’ll click on install right so once the installation is done I
will also have to install the SQL server management tools so the sequence of a management tools basically help us to connect with the database. I’ll click
on this and this will redirect us to the
Microsoft web page and over here I’d have to download the SQL server
management studio and I’ll be downloading the latest version
and this is the downloaded file over here SSMS setup enu, I’ll click on this, so
here we have these three options repair, uninstall and close. Now i have these
three options because I’ve already installed Microsoft SQL server
management studio in my system and if you are installing this for the first
time you’ll have the install button over here so you’d have to click on install
and the install would be done automatically right so once you install
the SQL server management tools, go to the search tool and type Microsoft
SQL server management studio click on this and Microsoft SQL server management studio will start so over here you’d have to specify the
password which you gave while creating the instance and then click on connect
and to start writing your SQL commands click on new query over here and then you can happily implement all of
your SQL commands right so this was the installation of
Microsoft SQL server.

2 Comments

  • Intellipaat

    Got a question on MS SQL Server Installation? Do write it in the comment and you will get a response immediately by our expert. For MS SQL Server training & certification, call us at US: 1800-216-8930 (Toll Free) or India: +917022374614. You can also write us at [email protected]

Leave a Reply

Your email address will not be published. Required fields are marked *