LLI Wiki — My Digital Knowledge Base

Fix the CImageHelper symbol file load error

Fix the SQL Server error CImageHelper::Init() Failed Load of symbol file by giving the full Binn path in the sqlctr.ini and sqlagtctr.ini files.

SQL Server can log CImageHelper::Init () Failed Load of symbol file with path when the counter definition files in the Binn folder reference a symbol file through the unresolved placeholder [SYMBOLINSTALLPATH]. Replacing the placeholder with the full path of the Binn folder and restarting the service resolves the error in the reported case.

Fix

  1. Open the Binn folder of the instance, for example C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn.
  2. Back up the files sqlctr.ini and sqlagtctr.ini.
  3. In each file, under the [info] section, replace [SYMBOLINSTALLPATH] in the symbolfile line with the full path of the Binn folder.
  4. Restart the SQL Server service.

The beginning of the edited file looks like this:

[info]
drivername=[DRIVERNAME]
symbolfile=C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn\sqlagtctr.h

Notes

Mastodon LLIMastodon SocialFosstodon