# Node Red Azure Error: No event 'socketConnect' in state 'Final'
**URL:** https://discourse.nodered.org/t/node-red-azure-error-no-event-socketconnect-in-state-final/28595
**Category:** General
**Created:** [19 June 2020 07:47 UTC](https://discourse.nodered.org/t/node-red-azure-error-no-event-socketconnect-in-state-final/28595 "2020-06-19T07:47:18Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@marwinwijaya](https://discourse.nodered.org/u/marwinwijaya)
#### Post date: [19 June 2020 07:47 UTC](https://discourse.nodered.org/t/node-red-azure-error-no-event-socketconnect-in-state-final/28595/1 "2020-06-19T07:47:18Z")
hello I have a problem with the azure sql node (node-red-contrib-azure-sql node) I tried sending data via MQTT mosquitto on Ubuntu, but it has the following error results:
> 19 Jun 07:35:37 - [info] [Azure SQL:Azure SQL] Trying to insert data into Database
> (node:2861) [DEP0064] DeprecationWarning: tls.createSecurePair() is deprecated. Please use tls.Socket instead.
> 19 Jun 07:35:37 - [info] [Azure SQL:Azure SQL] Connected
> 19 Jun 07:35:37 - [info] [Azure SQL:Azure SQL] Insert Complete. ID of inserted item is null
> Insert complete.
> 19 Jun 07:35:38 - [info] [Azure SQL:Azure SQL] String
> 19 Jun 07:35:38 - [info] [Azure SQL:Azure SQL] Trying to insert data into Database
> 19 Jun 07:35:38 - [info] [Azure SQL:Azure SQL] String
> 19 Jun 07:35:38 - [info] [Azure SQL:Azure SQL] Trying to insert data into Database
> 19 Jun 07:35:38 - [red] Uncaught Exception:
> 19 Jun 07:35:38 - Error: No event 'socketConnect' in state 'Final'
> at Connection.dispatchEvent (/root/.node-red/node\_modules/tedious/lib/connection.js:674:28)
> at Connection.socketConnect (/root/.node-red/node\_modules/tedious/lib/connection.js:698:19)
> at /root/.node-red/node\_modules/tedious/lib/connection.js:591:16
> at Socket.onConnect (/root/.node-red/node\_modules/tedious/lib/connector.js:176:9)
> at emitNone (events.js:106:13)
> at Socket.emit (events.js:208:7)
> at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1185:10)
Can you help me?
---
### Author:  [@marwinwijaya](https://discourse.nodered.org/u/marwinwijaya)
#### Post date: [19 June 2020 07:49 UTC](https://discourse.nodered.org/t/node-red-azure-error-no-event-socketconnect-in-state-final/28595/2 "2020-06-19T07:49:22Z")
This my Flow [Azure SQL](https://prnt.sc/t2k11g)
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [18 August 2020 07:49 UTC](https://discourse.nodered.org/t/node-red-azure-error-no-event-socketconnect-in-state-final/28595/3 "2020-08-18T07:49:23Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.