Issues with connecting to SQL Named Instance

Issues with connecting to SQL Named Instance


CT Suite v.3.2


Error

Getting connection refused

Log message

{"level":"info","message":"Obtained decrypted data creating CTAdmin DataSource","timestamp":"9/23/2019 14:02:08.0899"}

{"level":"info","message":"CTAdmin DataSource has been created","timestamp":"9/23/2019 14:02:09.0024"}

{"message":"Failed to connect to csqlcots16:1433 - connect ECONNREFUSED 10.100.12.81:1433","code":"ESOCKET","stack":"ConnectionError: Failed to connect to csqlcots16:1433 - connect ECONNREFUSED 10.100.12.81:1433\n    at ConnectionError (E:\\Program Files (x86)\\CTIntegrations\\CTSuite\\CT Configuration REST\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\errors.js:12:12)\n    at Connection.socketError (E:\\Program Files (x86)\\CTIntegrations\\CTSuite\\CT Configuration REST\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\connection.js:531:30)\n    at Socket.emit (events.js:193:13)\n    at Socket.EventEmitter.emit (domain.js:481:20)\n    at emitErrorNT (internal/streams/destroy.js:91:8)\n    at emitErrorAndCloseNT (internal/streams/destroy.js:59:3)\n    at processTicksAndRejections (internal/process/task_queues.js:81:17)","level":"error","timestamp":"9/23/2019 14:02:10.0054"}


Solution

Add the instance name to the URL string and remove the port to get it to work. It will work if used the  “/”. Tried adding it via the “\” and the service would crash on startup.

{

  "restApiRoot": "/api",

  "host": "0.0.0.0",

  "port": 3051,

  "AuthenticationURL": "http://LSACTIPRD101.GEHA.COM:3050/api/CTUsers/AuthenticateToken?Token={token}",

  "LoggerPath": "..\\Logs\\CTConfiguration.log",

  "RequireAuthentication": false,

  "CTControllerUrl": "http://LSACTIPRD101.GEHA.COM:8090",

  "CTControllerAuthorization": "EAAAAMZCn/W2BaGbQavdvrAuuMbQ9i2T93oXOGG+VVHj1AQS",

  "CTAdminDatabase": {

    "host": "cSQLCOTS16\\SQLCOTS",

    "port": 1433,

    "url": "mssql://CTAdmin:[CTAdminPassword]@cSQLCOTS16/SQLCOTS/CTAdmin?requestTimeout=120000",

    "database": "CTAdmin",

    "password": "[CTAdminPassword]",

    "name": "CTAdmin",

    "user": "CTAdmin",

    "connector": "mssql"

  },

 "CTAdminPassword": "CTAdminPassword==",

  "remoting": {

    "context": false,

    "rest": {

      "normalizeHttpPath": false,

      "xml": false

   },

    "json": {

      "strict": false,

      "limit": "50mb"

   },

    "urlencoded": {

      "extended": true,

      "limit": "50mb"

  },

    "cors": false,

    "handleErrors": false

  },

  "legacyExplorer": false,

  "useHttps": false

}

 

    • Related Articles

    • Release notes v3.2 SP1

      The CTS 3.2 SP1 is a cumulative release that includes fixes, enhancements and updates:   Fixes: 1465  - Outbound Call List Contacts Loaded redis entry not showing correct loaded contacts 1405 - Issue with Attachments getting corrupted 1468 - Email ...

    • Release notes v3.3

      Upgrade Path Based on the version currently installed, your system may need incremental upgrades to your system before you finalize on version 3.3.0 The following table illustrates the upgrade path required, depending on your current version. If you ...

    • Auto-Import New Users

      See Recording: https://workdrive.zohoexternal.com/external/24va2RAImOt-KGe3Q STEPS: HOW TO GENERATE A SCRIPT: 1. Send the CTS User Import.xlsm file (see attached) and have the customer fill in the columns that have a red header. 2. After filling in ...

    • Updating certificates on Windows and Linux servers

      What you need to know when updating CT Suite certificate on Windows App Server CT Suite uses a TLS Proxy called stunnel to terminate TLS connections made to the windows app server. Certificates have a lifetime that will expire and the length of ...

    • CT Suite for Amazon Connect V 4.0.8

      Issues addressed in this version: ISSUE NO ISSUE DESCRIPTION CSS-535 Supervisor staying in ACW after monitoring call Supervisor was monitoring a call, he dropped. Softphone state left him in ACW after he dropped from the call.  Resolution Notes: ...