Installing SQL Server 2012

This might be a simple article for the intermediate folks, however I would like to show you the screen’s in SQL Server 2012 installation. As far as I know the setup is similar to the one which we did for SQL Server 2008 R2, there are some additions to the installation part. Before jumping into the installation lets see the add-ons related to installation.

Features Added in SQL Server 2012 Installation

  • Operating System Requirement – SQL Server 2012 is supported only on Windows 7 , Windows Server 2008 R2 & above. SP1 is an mandatory requirement for OS else you won’t be able to proceed with installation.
  • Business Intelligence edition – This new edition supports BI related stuffs so it’s one power pack for your BI needs. For more details refer KB article
  • Enterprise Edition – You can now differentiate Enterprise edition based on licensing. CAL & Core based licensing are available for Ent Edition. If you noted I have mentioned it as Core based. Yes!! from 2012 the licensing model changes from processor to core.
  • Product Update – When you proceed with the installation you have the new feature to download updates for SQL Server during installation itself. This feature is like slipstream.
  • Server Core Installation – Now you can install SQL Server 2012 in Windows Server 2008 R2 Server Core (SP1 is required)
  • Multi-subnet clustering – Yep!! you are right now you can have your cluster nodes in different subnet masks, it’s supported in SQL Server 2012 clustering
  • SMB file share – System & User database can be placed in SMB file share. Incase of disk space issues, you can move your db files to file share!
  • Tempdb placement in Cluster – You are now allowed to place tempdb data files to a local drive in SQL Server cluster it’s not necessary to keep it in SAN disks.
  • Managed Service Account – Individual service account for all SQL Server related service to enhance security and isolate each service from one another

Features Removed in SQL Server 2012 Installation

  • Datacenter Edition – No longer available in SQL Server 2012, if you are running this edition then you need to get in touch with licensing team for upgrade options to SQL Server 2012
  • Itanium Support – Itanium processors are no longer supported
  • Active Directory Helper Service – This service is not installed as part of SQL installation as it’s no longer used.

Let’s proceed with the installation, insert your installation DVD and then click on setup


I’m going to install a stand alone SQL Server so I’m choosing option 1


Setup will validate your computer to install setup support files, once it’s done then only you will be able to launch actual SQL installation as shown below


Now provide the product key and then click next


Agree the license terms and then click next. If you want to share the data usage to Microsoft then enable the second option and the click next.


This is what I described earlier, now you will be able to check product updates during installation itself , if any updates are available then you can download and install it.


Now comes the actual SQL Server setup.


In this screen you are allowed to choose the setup role, first option will allow you to customize the features installed. Second option will install powerpivot for sharepoint servers and last option will install all the features with default values.


You can choose the features that’s required for you. In my case I’m going for all features for testing.


Next runs the installation rules, SP1 is required for Visual studio 2010 so if you don’t have that then your installation will fail.


Provide the details for database engine feature


Now it completes the disk space requirement for SQL 2012 installation


In this screen you are allowed to change the service account. If you could note all the service account are unique because it uses managed service account feature.


Now select the administrator account and which authentication to use. In addition to this you can enable Filestream feature which is require for playing with FileTables


Now select in which mode your analysis server need to be configured and also select the admin account


In this screen you need to select how to configure your reporting server. If you select the first option, report server will be installed and report server db’s will be created in the local instance. If you want to configure it to some other server then select the second option.


This is an optional value, incase if you face any error you can directly send it to Microsoft for further analysis. In real world, I hope none of them uses this option.


My installation rules are green and I’m good to go with installation





Ah!! I’m done with my installation and ready to test the features in RTM version. If you guys want to play with SQL Server 2012 then you can download enterprise evaluation version from the link . Let us know your feedback about the product.





Leave a Reply

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