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
- Open the
Binnfolder of the instance, for exampleC:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn. - Back up the files
sqlctr.iniandsqlagtctr.ini. - In each file, under the
[info]section, replace[SYMBOLINSTALLPATH]in thesymbolfileline with the full path of theBinnfolder. - 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
- The
symbolfilevalue ofsqlctr.iniis handled the same way, withsqlctr.has the file name. - The
[DRIVERNAME]placeholder is part of the original file and is left unchanged.