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:
-
1) Download and install the correct version of Microsoft's MSSQL Express 2008R2 from
www.microsoft.com The installers can be found here:
https://www.microsoft.com/en-us/download/details.aspx?id=30438
- You will want to select for download and install one of the 2 options shown below - depending on if you machine is 64 or 32 bit
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.
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:
These files are the 32 and 64 bit installers for MSSQL Express 2012SQLEXPR_x64_ENU.exe
and
SQLEXPR_x86_ENU.exe
- 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.