A while ago we had deployed a virtual server to use with Track-It. As we were using a standard template, with sysprep, to build our virtual hosts, this went well. During a regular audit of the event log, I noticed that errors were being generated by SmaRTIndexServer-Importer and SmaRTIndexServer-Indexer. So I decided to check up on them. The importer service was generating an error about not being able to find the SQL server:
Error loading Import Specifications: [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. -SELECT cmd_str, field_map, data_source, smi.area_id, poll_freq,import_id,attrs,last_run,update_cmd, import_type_id FROM smImports smi ORDER BY poll_freq
The indexer was generating a slightly different error message:
An error occurred when indexing answers: [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. -Unspecified error
Both suggested not being able to connect to the SQL server. So I checked up on the SQL server. I know it was running as I was using it earlier this morning for some inventory stuff. Knowing that was working, I started to look through google. There was no help there at all. So I turned to the knowledgebase for Track-It. Doing a search for “Error loading Import specificatons” found this gem.
A few reg changes later, and a restart of the service, and no more errors.