How do I connect to a named instance on an SQL Server database?

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:

  1. Navigate to the xMatters installation folder (the default location is C:\Program Files\xMatters\).
  2. In the \common\ subfolder, locate the common.properties file.
    • This file is encrypted and must be decrypted before you can edit it.
  3. To decrypt the common.properties file, run the following command:
APSecure.bat decrypt common\common.properties common.txt  
  1. 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  
  1. Modify the JDBC_URL line, using the following format for the value:
jdbc:jtds:sqlserver://;instance=  
  • For example,
JDBC_URL=jdbc:jtds:sqlserver://127.0.0.1;instance=XMATTERS  
  1. 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  
  1. Restart the Node and the web server.

xMatters Reference

JDN-1101 Originally created by Don Clark

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk