Installation of Microsoft SQL Server 2012 Step by Step

Step 1

Insert SQL Server 2012 installation media into your dvd drive/virtual disc drive.
At this point, you will be prompted (based on your Windows settings) with AutoPlay dialog as shown in the image below:

Click on Run SETUP.EXE (Alternatively you can launch set up by locating and double clicking on SETUP.EXE file on the media drive)

STEP 2:

If your OS is compatible, at this point the install should show you the SQL Server Installation Center.
Click on ‘Installation’.

STEP 3:

Click on ‘New SQL Server stand-alone installation or add features to an existing installation’

At this point, the install wizard will check for various setup rules and present you with any issues that needs to be resolved for set up to continue.

STEP 4:

In this step the install will ask for product key.  A default option of ‘Specify a free edition’ should be alreadt selected and ‘Evaluation’ is selected from the drop-down list.

STEP 5:

Accept SQL Server 2012  license terms and conditions .

STEP 6:

In the next screen, SQL Server 2012 install wizard will ask you to install setup files needed. Click on ‘Install’ button.

Once the setup files are installed, you should see the install complete scree.

STEP 7:

In this step make sure ‘SQL Server Feature Installation’ is selected and click Next to continue.

Step 8:

At this time you should see ‘Feature Selection’ screen.  I recommend you to click on ‘Select All’ if you are new to installing SQL Server.

STEP 9:

In this step you will be able to create a new SQL Server Instance.  However, I recommend to go with default settings.

STEP 10:

Installer will check your system for required disk space and provide you a summary

STEP 11:

Unlike previous versions of SQL Server, SQL Server 2012 uses an already created individual and independent service accounts for running various SQL Server services. Review and leave default options as-is (See image below).

Before clicking on Next to continue, click on collation tab and read through descriptions for your learning. Leave default selections as-is (see image below).

Click Next to continue.

STEP 12:

In this step, please follow the instructions carefully!!!
As you can see in the image below, you can have either windows authentication mode or mixed mode. Windows authentication mode lets you add only windows users while mixed mode lets you create users with a unique login and password.
Make sure you select Mixed Mode (converse to what is shown in the image below).
Enter a password for ‘sa’ account.
Also make sure to click on ‘Add Current User ‘ which will add the account with which you are currently logged in into windows as a admin account to SQL Server.
Note: Image below does not reflect the instructions above. Follow the instructions above carefully.
Click on Data Directories and FILESTREAM tabs and review for your learning (See images below).

Click Next to continue.

STEP 13:

Leave default selections as-is.
Make sure to click on ‘Add Current User’ which will add the account with which you are currently logged in into windows as an administrator account for Analysis Service Engine.

Click on Data Directories tab to review (see image below).















Click Next to continue.

STEP 14:

In this step leave the default options as-is.
Click Next to continue.

STEP 15:

In this step Click Add Current User to add your windows account as an administrator account for Distributed Replay Controller.

Click Next to continue.

STEP 16:

Leave the Controller Name blank and Click Next to Continue (see image below).

STEP 17:

Check box if you would like to send error reports to Microsoft. I have left it as-is (see image below).

Click Next to Continue.
At this point, set up will again verify your system for any potential blocking issues.
Once the operation is completed, click Next to continue (see image below).

STEP 18:

Review the options you selected for the install and verify the path to which configuration file will be stored. You can take advantage of this configuration file for future installs.
Click ‘Install’ to begin Installation.

Installer will take a while in this step before the installation is complete.



and the installation of SQL server is done. 

Thanks & Regards
 Srikanth Goud- Virtualization Administrator