mO SharemO Share

How To: Install SQL Server 2012 Express Edition in POS

Owned by Ginesys Knowledge Team
Last updated: Jul 15, 2019 by Aparajita Basu Roy
4 min read

When new a POS site is being opened with SQL Server 2012 Express edition database or an existing POS site is installing a new SQL Server 2012 database, you would need to know the following information.


Important: Please ensure the following before you start the installation

  • Server Machine Name and Windows User Name (who is installing) must not be same. Please change the Windows User Name if you are having this scenario.
  • Uninstall all previous instances of SQL Server installations before proceeding with the current installations.
  • Please leave all check boxes, that are not mentioned in Step 3, unchecked for smooth installation of the software.
  • Some of the steps will be skipped by the SQL Server 2012 Installation Wizard if no changes are needed in their default settings; however, you can always click on the Back button from the next screen to check the skipped screens. For example, if no installation rules are contradicted by the Feature Selection process, then you will not see the Installation Rules screen. The process will move directly on to the Instance Configuration screen. In case you wish to check the installation rules, click on the Back button from the Instance Configuration screen.

Step-by-step guide

Step No.

StepsImage
1.

Run the SQL Server 2012 Express edition by double clicking it and select the " New SQL Server stand-alone installation or add features to an existing installation" option.

It will show a message of "Please wait while Microsoft SQL Server 2012 Setup processes the current operation".
 

2.Accept the licensing terms by checking the box - " I accept the license terms." and clicking on the Next button.
 
3.

In the Feature Selection screen, select the following features:

  1. Instance Features

    1. Database Engine Service - CHECKED
      1. SQL Server Replication - UN-CHECKED
      2. Full-Text and Semantic Extractions for Search - UN-CHECKED
  2. Shared Features

    1. SQL Server Data Tools - CHECKED
    2. Client Tools Connectivity - CHECKED
    3. Client Tools Backward Compatibility - CHECKED
    4. Client Tools SDK - CHECKED
    5. Management Tools - Basic - CHECKED
      1. Management Tools - Complete - CHECKED 
    6. SQL Client Connectivity SDK - CHECKED


Now click on the Next button, to move to the next step.


4.

In Instance Configuration screen, check the following details:

  1. Select the Default instance option.
     
  2. The Instance ID should be "MSSQLSERVER". (In case you find the Instance ID for Default instance to be something else, please contact our Helpdesk at support.ginesys.in)
     
  3. Instance root directory should be "C:\Program Files\Microsoft SQL Server\".

  4. SQL Server directory should be "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER".
     
  5. Reporting Services directory should be "C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER".


Now click on the Next button, to move to the next step.

5.

If your Disk Space Requirements are adequately fulfilled, that screen will be skipped to move to Server Configuration. In the Server Configuration screen check the following details:

  1. SQL Server Database Engine -Account name: NT Service\MSSQLServer ; Startup type: Automatic
     
  2. SQL Full-text Filter Daemon Launcher - Account name: NT Service\MSSQLFDLauncher ; Startup type: Manual
     
  3. SQL Server Browser - Account name: NT AUTHORITY\LOCAL SERVICE ; Startup type: Disabled


Now click on the Next button, to move to the next step.

6.

In the next Database Engine Configuration screen, the Server Configuration tab should have the following details as given below:

  1. For Authentication Mode select the Mixed Mode (SQL Server authentication and Windows authentication)

  2. SQL Server system administrator (sa) account should be given a suitable password and it must be confirmed.


Now click on the Next button, to move to the next step. 

7.

In the next Database Engine Configuration screen, the Data Directories tab should have the following details as given below:

  1. Data root directory : C:\Program Files\Microsoft SQL Server\
     
  2. System database directory : C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data
     
  3. User database directory : C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data
     
  4. User database log directory : C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data

  5. Temp DB directory : C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data
     
  6. Temp DB log directory : C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data
     
  7. Backup directory: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup 

Now click on the Next button, to move to the next step.
 

8.

The optional Error Reporting screen is shown. You may check the box here to send the Windows and SQL Error Reports to Microsoft.

Now click on the Next button, to move to the next step.


9.

The Installation Configuration Rules and Installation Progress screens will quickly skip to reach the Complete screen which will show in details the features installed through this installation process.