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 use SQL with windows authentication

      By default, the AxTraxNG server will use the SQLinternal user logins (sa user) as set by the default AxTraxNG installer. In some cases, you might be needed to use windows authentication for SQL login, there are some requirements needed to be done to ...
    • How to obtain AxTraxPro server logs.

      In some cases Rosslare Technical support specialist will request that you will  send us the AxTraxPro server logs.  To obtain the logs go to AxTraxNG server installation folder under this path: C:\Program Files (x86)\Rosslare\AxTraxPro Server Look ...
    • 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

    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