How to install SQL server (VERITRAX instance) Manually

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. 

Requirements:  

  1. .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. 
  2. 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. 

  1.  Download the software from Microsoft at the following link; http://www.microsoft.com/en-us/download/details.aspx?id=29062 
    1. Select Download. 
    2. Select the file ENU\x86\SQLEXPR_x86_ENU.exe
      (this file contains both the 32 and 64 bit versions) 
  2. Run the installer, right click the file and select “Run as Administrator”.
  3. Select New SQL Server stand-alone installation:
  4. Accept the License Terms and press NEXT:
  5. At the Product Updates screen select NEXT:
  6. On the Feature Selection screen insure that Database Engine Services are enabled and the other options are not then select NEXT:
  7. On the Instance Configuration screen, enter “Veritrax” without the quotes for the new instance name as shown in Figure 5 then select NEXT: 
  8. On the Server Configuration screen enter the Account Name to NT Authority\system by typing it as shown the then select NEXT:
  9. On the Database Engine Configuration screen change the Authentication Mode to Mixed Mode and TYPE the following Password in both blanks;  Bod33|en17?ha! 
  10. 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
  11. 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. 

    • Related Articles

    • How to connect AxTraxNG server to remote SQL server

      Before starting this process please make sure that the SQL server meets AxTraxNG server supported SQL servers. Which versions of SQL Server does AxTraxNG support? To connect the AxTraxNG server to a remote SQL server please follow this guide. As ...
    • How to obtain AxTraxNG server logs.

      In some cases Rosslare Technical support specialist will request that you will  send us the AxTraxNG server logs.  To obtain the logs go to AxTraxNG server installation folder under this path: C:\Program Files (x86)\Rosslare\AxTraxNG Server Look for ...
    • Which versions of SQL Server does AxTraxNG support?

      AxTraxNG server supports the following versions of MS-SQL servers: MS-SQL 2008 MS-SQL 2012 MS-SQL 2014 MS-SQL 2016 MS-SQL 2017 Starting version 27.7.1.18 AxTraxNG supports the above SQL servers with addition: MS-SQL 2019
    • What are the minimum requirments for AxTraxNG Server and Client installation

      The minimum spec for AxTraxNG Server and Client  as listed in the manual are: CPU: 2.4GHZ (i5) or higer OS: win 7 or higher, up to win server 2019is supported. RAM: 4GB Network: network adapter 100MB Hard Drive: 5GB of free space This is minimum ...
    • How to install and set AxTraxNG remote client

      When a remote AxTraxNG client connection is need to AxTraxNG server you can achieve this in few simple steps: Please note that AxTraxNG server and AxTraxNG client Must use the same version Please set the firewall rules on AxTraxNG server Machine ...

    Couldn't find what you are looking for?

    Please feel free to contact us:

    NORTH AMERICA & CANADA

    Toll Free: 1 866 632 1101
    Telephone: 1 817 305 0006

    EUROPE

    Telephone: 972 4 9577 183

    LATIN AMERICA

    Telephone:  54 11 4001 3104

    APAC, MIDDLE EAST AND AFRICA

    Telephone: 852 2795 5630

    CHINA

    Telephone: 86 755 8610 6842

    INDIA

    Telephone: 91 20 40147830