Install SQL Server 2012 step by step
Articles,  Blog

Install SQL Server 2012 step by step


Hello youtube this is me indra and in this
tutorial i will show you how to download and install sql server 2012 so for that you need
to download sql server database engine and management studio so let us begin first of
all open your web browser and type download sql server 2012 then after click on the official
link that is the first one then after go down of the page then after you will see microsoft
sql server 2012 express edition and before download be sure that your computer fulfills
all the basic requirement to install the server for example your computer may be of 32 bit
or 64 bit you need to check that and your processor speed and size and storage capacity
size of ram you need to check at first then after click on download and be careful here
if your operation system is of 32 bit then you have to download the enu *86 server other
wise if your operating system is of 64 bit the first one this one and management studio
this one you need to download this two and click on next if your operating system is
of 64 bit if your operating system is of 32 bit then you need to download management studio
32 bit and sql server express edition 32 bit here my operating system is of 64 bit so i
will download for 64 bit operating system that is sql server database engine and management
studio then after click on next so it will start download now the management studio is
of about 600 mb and that of database engine is 130 mb so it will take some time just wait
for the moment ok the download completes and you can find it on download folder go to the
download folder then after double click on programs here we can find the programs so
first of all we need to install the database engine so database engine is the service for
storing processing and securing the data so let us install this it will take some time
to extract the file you need to wait for some moment to complete the extraction process
then click on yes so the set up is started now now this is the first time that we are
going to install the sql server so this is the installation center of sql server 2012
database engine form here we can perform standalone installation of sql server and we can also
add any additional features to install instance of sql server so we want to perfrom standalone
installation so click on the first link it may take some time so setup support rules
are checked we have to wait for it so we have to accept the licence agreement check this
licence agreement then after no need to check the second one then click on next so we need
to download this update so click on next it may take some time depending on the internet
speed and that is going to be completed now so the extraction is in progress installation setup is in progress finally the update is completed now again it checks for the setup support
files and rules then after we are going to install the database engine and it should
be checked and this is the location where we are going to install the database engine
so i keep it as default and click on next for this you need to have .net framework install in your computer if it is not installed it will be installed automatically and about instances since this is my first installation of sql server i will choose the default instance if you have previously installed you have to processed with the named instance since
this is my new installation so click on the default instance and click on next if there
are any instance it will be listed here then after so sql server database engine and service
account sql server browser and collation is for setting the default character set sort
order and case sensitivity of the instance so let it be as default and click on next so this is the important area where we have to provide the authentication type i will
be using mixed mode authentication where we have to enter the password in order to login
in the sql server database engine then after click on next leave other as it is let it
be in default setting and click on next and it is not compulsory that you should check
this then click on next so the installation is in progress it will take some time it may
take up to 10-15 minutes we have to wait for this so by this we have completed the installation
of sql server database engine again we have to install the sql server management studio
also so click on close we have successfully install all these now close all this then
after we have to install the sql server management studio again so double click on this it will
take some time to extract the file and then after click on yes so the setup is going to
process then after this is the installation of sql server management studio now click
on new sql server standalone installation again it will check the setup support rules when it is passed it will redirect to next interface again it is checking for the update
so there is no update available so click on next it may take some time so by default perform new installation of
sql server 2012 i have selected here and i will perform the default setup for here then after accept the licence agreement and click on next so here we are going to install management tools so it is checked here so you have to check this one and click on next we donot need local db management studio is sufficient for us after no need to check this click
on next now it will take sometime so by this we have completed the installation of sql
server management tool then after click on the the close button and close this also now let us check whether it is installed properly or not for that go to start and search management
tools management studio it may take some time while it is loading for the first time ok let me connect it with windows authentication at first so it gets connected here we can
view the database now let me yes we can view the database here now let me close it again
close it and open with the administrator again management studio then after i will provide
the sql server authentication provide the username sa and provide the password that
you have used you have typed earlier then click on connect so it works fine so by this
we have successfully installed sql server database engine and management studio you
can find the versions also from here thanks for watching hope you like my videos and please
subscribe my channel thank you

49 Comments

Leave a Reply

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