Installation of SQL Server 2012 on Windows

Share us

Installation of SQL server 2012 Enterprise Edition on Windows

To install SQL Server 2012, we need to follow below mentioned steps:

step 1: Go to the location where setup file of SQL Server is kept. Right click on the setup file and run this as an administrator.

Locaiton_1

Step 2: Installation Center

After running setup file, we will be redirected to Installation Center, where we will find different sorts of options like planning, installation, Maintenance etc.

Location_2

We will click on the installation section and it will be something like below:

Location_3

We will perform New SQL Server stand-alone  installation of SQL Server. We can also add additional features to exiting installed instances of SQL server. Also we can upgrade the SQL Server. Here we will be focusing on installing stand-alone.

Step 3: Setup support Rules

SQL Server basically  checks whether all things required for installation met or not. So this is a kind of verification from SQL server end.

Location_4If anythings fails, we will get a failed notification in status column and we will not be able to proceed further.

Step 4: Install Setup Files

Here setup files will be installed and also if any update for SQL Server setup is found and specified to be included, the update will also be installed.

Location_5

Once setup files are installed along with updated setup if any found, setup support rules will be looks like something below and gives summary of setup support rules. We can get warning in status. It is okay for dev environment, but in production we need to fix those warnings. Click on next.

Location_6

Step 5: Installation Type

Here it will basically tell what kind of installation we want, either we can perform new installation or add feature to an existing instance of SQL Server.  We will select first option i.e. perform new installation of SQL Server 2012.

 

Location_7

In above screenshot, we can see we have already installed different instance of SQL Server.

Step 6: Product Key

Just enter the SQL Server we want to install with product Key and click next.

Location_8

Step 7:  License Term

We just need to accept the license by clicking on “I accept license terms”. Click next

Location_9

Step 8: Setup Role

In setup role, we will select SQL Server features installation, which basically includes Database Engine services, Analysis services, Reporting service and Integration services and  other features.

Location_10

Step 9: Feature installation

Here we will select the features that we want to  included in our SQL Server. Basically we have instance features and Shared features. We select the features according to our requirements.

Location_25

 

Step 10: Installation Rules

Here setup again runs to make ensure our machine is compatible for further process or not.

Location_12

If everything is fine, then click next.

Step 11: Instance Configuration

Here we need to decide what kind of configuration we want for that instance. SQL Server offers two kind of instance configuration.

Location_13

Default instance – its name will be same as windows name.

Named instance- we can give the name as per our requirement or choices.

If default instance is already installed, then we have to do named instance configuration. In my case I am doing named instance configuration.

Step 12: Disk Space Requirements Summary

This basically tells us, how much disk space will be taken for that particular instance by our machine.

Location_14

Step 13: Server Configuration

Here we can specify the  service account name and their password, if that is provided. Along this we can specify startup type as Manual or Automatic. Recommendation is to select Services to Automatic.

Location_15

Step 14: Database Engine Configuration

Here we will get three tabs- Server Configuration, Data Directories and FILESTREAM

Server Configuration basically tells about the authentication mode we want. I have selected Mixed Mode and specify the password. and added current user.

Location_16

Data Directories- It consists of below

Data root directory,System database directory, User database directory, User database log directory, Temp data and log directory, Backup directory.

Location_17

As per standard of SQL Server in production environment, it is recommended that we should provide different directory for Data, Log, Tempdb and Backup, otherwise performance of SQL Server will hamper.

On FILESTREAM tab, we will find the option to enable the FILESTREAM feature.

Step 15:  Error Reporting

Location_18

Click next

Step 16: Installation Configuration Rules

This is the final step where setup will perform a final check to make sure everything is fulfilled to install the SQL Server.

Location_19

Step 17: Installation Summary

We will get the installation summary as below depicted. Just click on install button and we are set to go.

Location_20

Step 18: Installation Process

Finally installation process will start and we will see the status bar of the completion of the installation.

Location_21

Step 19: Installation Complete

Once installation is done successfully, we will see below window and it will display the components installed in our machine for SQL Server with succeed message in status bar.

Location_22

Step 20: Verification of the installed instance

Open SSMS and connect the instance that we have just installed. We are good to verify.

Location_23

Use New Query and write- Select @@servername as Server_Name, Also to know about version of SQL we installed write- Select @@version as SQL_Server_Verison

Location_24

Conclusion

We have finally installed SQL Server 2012 named instance successfully on our machine. In case of any failure during installation, like power off etc, it is highly recommended to uninstall all components related to SQL Server 2012 from Control panel and do a fresh installation.

Feel free to share your views and comments.

 

 

 

 

22 Commentsto Installation of SQL Server 2012 on Windows

  1. MAGGY MEGG says:

    Hi Suraj. I love it

  2. Jeetendra says:

    Nice blog by author

  3. Balaram Ghosh says:

    This is very helpful. Thanks Suraj…

  4. Balaram Ghosh says:

    This is very helpful.Thanks Suraj…

  5. Natarajan Palani says:

    It’s really useful… Appreciate you for this blog…

  6. Sasikumar says:

    Nice blog

  7. Hareesh Vaddi says:

    Nice to remember all those things.Loved it Suraj Bhai..

  8. Banupriya says:

    Nice blog👍

  9. Dhivya P says:

    Nice blog..Will be helpful for many..

  10. Kumar Saurav says:

    Good one to start with Suraj. Keep it up the habit of writing blogs it really helps.

  11. I have to thank you for the efforts you have put in penning this blog.
    I am hoping to view the same high-grade blog posts by you in the
    future as well. In truth, your creative writing abilities has
    inspired me to get my very own website now 😉

  12. It’s an amazing post for all the web visitors; they will obtain benefit
    from it I am sure.

  13. I carry on listening to the news broadcast talk about getting free online grant applications so I have been looking around for the most excellent site to get one. Could you advise me please, where could i find some?

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.