mO SharemO Share

"Could not load file or assembly 'Microsoft.SqlServer.SMO, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc891' or one of its dependencies. The system cannot find the file specified." - Error message is displayed while opening GINESYS Web

Owned by
Aparajita Basu Roy
Sept 15, 2022

SYMPTOMS

GINESYS Web may not open and the following error message would be shown.

Could not load file or assembly 'Microsoft.SqlServer.SMO, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc891' or one of its dependencies. The system cannot find the file specified.

CAUSE

One of the probable causes for this issue is the existence of GINESYS HO and GINESYS POS in the same machine. GINESYS HO and GINESYS POS cannot co-exist on same machine on a production environment since installation of GINESYS POS overwrites the newer SQL Server SMO assembly files required by GINESYS Web with older version ones supplied with GINESYS POS.

Alert

It is strongly discouraged that you try to tweak the installation by attempting to install both versions of SQL Server assemblies which may cause further database connectivity issues.


RESOLUTION

Execute the following steps to resolve your issue:

  1. Uninstall GINESYS POS from the GINESYS Server.
     
  2. Follow the path given below to locate the SQL 2012 Client Tools
    <GINESYS Installation Drive>\GSL\GINESYS12\Shared\Dumps\SQL2012ClientTools\x64
     
  3. Install all the following components that are available there, as below - 
    1.  Shared Management Objects
    2.  SqlCmdLnUtils 
    3.  sqlncli [under this select the option - Entire feature will be installed on local hard drive.]
    4.  SQLSysClrTypes
       
  4. Now attempt to open GINESYS Web.
     
  5. It should now open normally.

This should resolve your issue, in case you face it again please contact our Ginesys Care portal - https://care.ginesys.in/