Symptom
When attempting an archive or purge your database, you see one of the following errors:
When observed in System Administration, you see the following connection error:
Resolution
In most cases, the issue is resolved by executing the following SQL query: insert into LNLCONFIG (LNLSTRING, LNLCONFIGID)
values ('server_name', '178') Note: Replace 'server_name' with your actual database server name. If it is the port that is determined to be the issue, then perform the following procedure:
- Open the following:
C:\Windows\SysWOW64\cliconfg.exe
C:\Windows\cliconfg.exe - Under the General tab, add TCP/IP to the Enabled protocols by order field.
- Click Properties and change the value of the Default port field to the custom port used by the SQL server.
- Go to the Alias tab, then click [Add].
- Add a new alias in the Server alias field. Make note of this alias because you will need it during the installation.
- In the Network libraries section, select the TCP/IP radio button.
- In the Connection parameters section, specify the SQL server in the Server name field.
- De-select the Dynamically determine port check box.
- In the Port number field, enter the port number that the SQL server is monitoring.
- Click [OK] [OK]. You can now specify the server alias name used in Step 5 during the production installation phase corresponding to the database.
Applies To
OnGuard (all versions)
Additional Information
© 2024 Honeywell International Inc. All Rights Reserved.
Your Privacy Choices