How to install SQL server (VERITRAX instance) Manually

On some cases the Automatic installation of SQL server on the machine might fails due to conflicts found on the machine or other issues, in those cases we recommend that SQL server will be installed manually.

This Article will show you how to install a SQL server step by step.

if you desire to install the SQL server not at default Instance and "sa" password you will have to set AxTraxNG server SQL connection details following the SQL server you installed.

Please note when using SQL 2017, "sa" login is disabled by default and have to be enabled so AxTraxNG can work.

The Password mentioned in this article is the default AxTraxNG password and should be changed

Requirements:

.NET 4.0 is a requirement for SQL Server 2012. SQL Server installs .NET 4.0 during the feature installation step. If you are installing the SQL Server Express editions, ensure that an Internet connection is available on the computer. SQL Server Setup downloads and installs the .NET Framework 4 because it is not included in the SQL Server Express media.
If you run Setup on a computer with the Windows Server 2012 or Windows 8 operating system, the SQL Server Setup automatically downloads and installs the .NET Framework 3.5 SP1. This process requires internet access. If there is no internet access, it is required to download and install .NET Framework 3.5 SP1 before you run Setup to install any of the above mentioned components.

SQL server installation step by step:

This Article point to SQL server 2012 32bit express version installation but can be use for any other version from 2012 till 2017.

Download the software from Microsoft at the following link; http://www.microsoft.com/en-us/download/details.aspx?id=29062

Select Download.
Select the file ENU\x86\SQLEXPR_x86_ENU.exe
(this file contains both the 32 and 64 bit versions)

Run the installer, right click the file and select “Run as Administrator”.
Select New SQL Server stand-alone installation:
Accept the License Terms and press NEXT:
At the Product Updates screen select NEXT:
On the Feature Selection screen insure that Database Engine Services are enabled and the other options are not then select NEXT:
On the Instance Configuration screen, enter “Veritrax” without the quotes for the new instance name as shown in Figure 5 then select NEXT:
On the Server Configuration screen enter the Account Name to NT Authority\system by typing it as shown the then select NEXT:
On the Database Engine Configuration screen change the Authentication Mode to Mixed Mode and TYPE the following Password in both blanks; Bod33|en17?ha!
On the Error Reporting screen just select NEXT:

After this step, the actual installation will run. This will take several minutes even on a fast computer. Do not interrupt the installation or cancel it as a partial installation can be very difficult to recover from. Several different screens will come up as the installation progresses, be patient until the complete screen comes up
If the installation works properly you will get the following screen showing all of the components installed, just click CLOSE to exit the installer:

Connecting with AxTraxNG:

If the Installation is completed successfully you should reboot the Machine at this point and AxTraxNG server should connect to the SQL server without any issue.