Installation of SQL server 2012
In this blog post on SQL server, we are going to cover Installation of SQL server 2012.
Hardware and software requirements:
We start by going over the hardware and software requirements for SQL 2012 installation. This includes things like:
- CPU: For x86 1 GHz or faster, 2 GHz is recommended
- Operating System: SQL 2012 will run on Windows Vista, 7 and 2008
- RAM: Minimum 1 GB, recommended is 4 GB
- Hard Disk: You need 3 GB of disk space
- Also you need .NET framework 3.5 and IE 7 0 for SQL 2012 install.
Additional information is available from web site.
For the purposes of this SQL 2012 install, we are going to use the 3 files option. Once the 3 files are downloaded, you can extract the SQL 2012 Server installation files to a folder. You can get to these files from this location:
Next we run the SETUP.EXE which will launch the SQL Server 2012 Installation center. This is shown right below.
Here we select the Installation option in the left pane and New SQL Server installation in the right pane. Before any software is installed, you need SQL 2012 setup support files. Another way to think about is prerequisite for your SQL server installation.
This is shown in the SQL 2012 Server screenshot below:
Next we are going to choose a set of options including which SQL 2012 server installation, for this one we choose Free edition of SQL Server Evaluation version. On the next screen, we choose SQL Server Feature selection. This includes SQL 2012 features like database engine, SSIS, management tool (SSMS), Integration services, Reporting services, Authentication choices, etc.
Here is what the screenshot looks like for our SQL 2012 install:
We make our SQL Server feature selection and click Next. We highlight SQL Server 2012 “Best Practices” that are used in the industry and then continue the process. This includes items like location of software files, database files, log files and other vital points.
Here is what it looks like on our computer for SQL 2012 Instance Configuration.
For Server Configuration in SQL 2012, it is preferred to use a dedicated domain account. This applies to the database engine service, SQL Server Agent and also other items like SSRS, SSIS and SSAS. For authentication, we use Mixed Mode Authentication. This allows access to SQL Server from Windows and Non-windows environments. Here is a screen capture on the SQL Server installation step.
After all the Installation selections have been made for SQL Server 2012, we get a final summary window. This highlights all the different options you have picked for your SQL Server installation. Please review before you move on to the next screen. We have included a computer monitor picture of this right below:
Go ahead and choose Install. This is when the SQL Server install takes a long time. Why? Because it is copying all the necessary files from installation directory to your computer. If you are falling asleep in the process, this is a good time to get your coffee or tea!!
Here is what it looks like on our end.
At the end of this process, a setup logfile is generated which has all the information regarding the SQL 2012 installation. This should be stored in a secure place. After SQL 2012 installation finishes, you can use the SQL Server Management Studio and verify that the installation process went smoothly. In addition, you can check the MS SQL services using Configuration Manager.
A final confirmation of the SQL 2012 Server installation is as follows: