Product: 
EzParts Electronic Parts Catalog Software.

 

Problem: 

Sytems Online's EzParts software requires MSSQL Express 2008 R2 or higher on all machines when installing EzParts.  We configure default settings for the installer that are compatible with most machines.  However,  in some cases, some computer settings on users computer preventing the install from functioning properly when called from our setup application.  this is usually due to group policy or security settings.  Since we do not display MSSQL Express options to the user during the install, it will be necessary to run the MSSQL express Installer from Microsoft manually in order to install this dependency on the users machine.


Resolution:

Determine what minimum version of MSSQL that is supported by your manufacturer's data set.  If necessary, send an email to our support team with the manufacturer information and we will assist you in identifying what minimum version of MSSQL is support for any manufacturer.


If manufacturer data set's minimum version of MSSQL Express is 2008R2 or newer, follow these steps:


  • 2) Install MSSQL using the installer that you downloaded.  It is CRITICAL that you set 2 setup options correctly:

       The first install option is the "instance name" 

        
         It is important that you specify instance name 'EZPARTS5_2008R2' 
             This will allow EzParts installs to identify the correct instance for restoring the MSSQL database in the future.

       The Second install option is "Mixed Mode" security

    • Additionally - you may receive a "Warning" that MSSQL Express 2008R2 is not support on Windows 10.  If you receive this warning - you can continue the installation.  This DOES NOT mean it is not compatible, it simply means that Microsoft support will not assist with install issues.

    • 3) After you have completed the install for MSSQL Express 2008R2 from Microsoft, run the EzParts Setup again.  The EzParts setup will recognize the installed instance of MSSQL 

    •  If you receive the MSXML error after installing MSSQL Express and re-running the EzParts Installer - PLEASE CONTINUE the install and, DO NOT ABORT.  


    After installing MSSQL Express please Launch the EzParts Installer.  EzParts will detect that MSSQL is installed and install the EzParts Electronic Parts Catalog (EPC) and manufacturer's data set.


    If the manufacturer Data set's minimum version of MSSQL Express is 2012 or newer, please follow these steps:

     

    • 1) Browse to the "Soft" folder on your installation disk and look for the two files:
    SQLEXPR_x64_ENU.exe 
    and
    SQLEXPR_x86_ENU.exe
     These files are the 32 and 64 bit installers for MSSQL Express 2012
    • You will want to select for download and install the correct file based on your operating system.  
      • If you have 64bit windows install using:  SQLEXPR_x64_ENU.exe 
      • otherwise install usingt: SQLEXPR_x86_ENU.exe

    • 2) Install MSSQL using the installer that you selected.  It is CRITICAL that you set 2 setup options correctly:

         The first install option is the "instance name" 

          
           It is important that you specify instance name 'EZPARTS5_2012' 
               This will allow EzParts installs to identify the correct instance for restoring the MSSQL database in the future.

         The Second install option is "Mixed Mode" security

    • 3) After you have completed the install for MSSQL Express 2012 from Microsoft, run the EzParts Setup again.  The EzParts setup will recognize the installed instance of MSSQL 


    • If you receive the MSXML error after installing MSSQL Express and re-running the EzParts Installer - PLEASE CONTINUE the install and, DO NOT ABORT.  

     

    After installing MSSQL Express please Launch the EzParts Installer.  EzParts will detect that MSSQL is installed and install the EzParts Electronic Parts Catalog (EPC) and manufacturer's data set.