# Azure SQL: what node to use?
**URL:** https://discourse.nodered.org/t/azure-sql-what-node-to-use/21119
**Category:** General
**Created:** [31 January 2020 22:10 UTC](https://discourse.nodered.org/t/azure-sql-what-node-to-use/21119 "2020-01-31T22:10:21Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@bence](https://discourse.nodered.org/u/bence)
#### Post date: [31 January 2020 22:10 UTC](https://discourse.nodered.org/t/azure-sql-what-node-to-use/21119/1 "2020-01-31T22:10:21Z")
Hi,
anyone succeded in connecting to Azure SQL database and inserting/selecting data? I tried two nodes, but I run into problems with both.
The situation: I want to insert tons of data with INSERT command, so I call sql command like in every 3 seconds.
With node-red-contrib-azure-sql I experienced that after 50-60 calls I always run into this error message:
31 Jan 13:57:07 - Error: No event 'socketConnect' in state 'Final'
at Connection.dispatchEvent (C:\Users\Administrator.node-red\node\_modules\tedious\lib\connection.js:674:28)
at Connection.socketConnect (C:\Users\Administrator.node-red\node\_modules\tedious\lib\connection.js:698:19)
With node-red-contrib-mssql-plus I am not able to connect to azure sql: I always get the error message "Login failed for user 'USERNAME'.","name":"ConnectionError"
General options like username, pw, network access (firewall etc) are checked, connection is working from other client/admin programs.
Is there an SQL node what can be used especially for azure SQL server?
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [31 March 2020 22:10 UTC](https://discourse.nodered.org/t/azure-sql-what-node-to-use/21119/2 "2020-03-31T22:10:27Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.