Occasionally, rebooting an SQL Server database causes the port numbers assigned to the xMatters database to be dynamically reassigned. This cause a loss of connection between xMatters and the database. Is there a way to connect to a named instance, rather than a port number?
You can edit the connection information in the properties file to connect to a named instance instead of a port number.
NOTE: The xMatters installer does not allow a named instance to be used. You must first install the database against a port, and then change the database connection based on this article.
To change the database connection credentials:
- Navigate to the xMatters installation folder (the default location is C:\Program Files\xMatters\).
- In the \common\ subfolder, locate the common.properties file.
- This file is encrypted and must be decrypted before you can edit it.
- To decrypt the common.properties file, run the following command:
APSecure.bat decrypt common\common.properties common.txt
- Once the file is decrypted, open it in a text editor and locate the following section:
#Mon DEC 15 15:23:10 PDT 2008 JDBC_DRIVER_CLASS_NAME=net.sourceforge.jtds.jdbc.Driver JDBC_USERNAME=ALARMPOINT321 JDBC_URL=jdbc\:jtds\:sqlserver\://127.0.0.1\:1433 JDBC_PASSWORD=password
- Modify the JDBC_URL line, using the following format for the value:
- For example,
- Save and close the common.properties file, and then run the following command to encrypt the file again:
APSecure.bat encrypt common.txt common\common.properties
- Restart the Node and the web server.
JDN-1101 Originally created by Don Clark