Installing SQL Server 2017 Express for Ginesys POS

Download Link :

SQL Server 2017 Express Edition: http://support.ginesys.in/downloads/current/SQLEXPR_x64_ENU_2017.exe

SQL Server Management Studio 2017: http://support.ginesys.in/downloads/current/SSMS-Setup-ENU_2017.exe

Note: Also you may directly download the SQL Server Setup ( Bootstrap file name like : SQLServer2017-SSEI-Expr.exe ) from the below Microsoft link and it will guide you the entire download & installation process of SQL server 2017 setup & SSMS setup separately.

Alternate source from Microsoft:

https://www.microsoft.com/en-in/sql-server/sql-server-editions-express

SQLServer2017-SSEI-Expr.exe

Pre-installation checks

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 Computer name or Windows User Name in such cases.
Better uninstall all previous instances of SQL Server installations, if not in use, before proceeding with the current installations.
The feature selected in Step 3 is sufficient for Ginesys operation. Keep other feature unchecked for optimum performance.

Step-by-step installation guide

Step No.	Steps	Image
1.	Setup File Name: SQLEXPR_x64_ENU_2017.exe Run the SQL Server 2017 Express edition by right clicking on it & choose RUN AS Administrator then setup will be extracted and click on OK. 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 2017 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.	You can check for Microsoft update, which will download important updates for windows & other Microsoft software including SQL server 2017. But is not mandatory , you can else ignore it.
4.	Post that Pre-installation rules check will identify potential problems that might occur while running setup, Failures must be corrected before setup.
5.	In the Feature Selection screen, select the following features: Instance Features Database Engine Service -CHECKED SQL Server Replication -*UN-CHECKED* Shared Features a. SQL Client Connectivity SDK - UN-CHECKED Now click on the Next button, to move to the next step.
6.	In Instance Configuration screen, check the following details: Select the Default instance option. 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) Instance root directory should be "C:\Program Files\Microsoft SQL Server\". SQL Server directory should be "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER". Reporting Services directory should be "C:\Program Files\Microsoft SQL Server\MSRS14.MSSQLSERVER". Now click on the Next button, to move to the next step.
7.	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: SQL Server Database Engine -Account name: NT AUTHORITY\Local Service;Startup type:Automatic SQL Server Browser-Account name:NT AUTHORITY\LOCAL SERVICE;Startup type:Disabled Now click on the Next* button, to move to the next step.*
8.	In the next Database Engine Configuration screen, the Server Configuration tab should have the following details as given below: For Authentication Mode select the Mixed Mode (SQL Server authentication and Windows authentication) 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.
09.	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.