# No puedo conectar Azure SQL

**URL:** <https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359>\
**Category:** General\
**Tags:** database, function-node\
**Created:** [17 February 2023 17:11 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359 "2023-02-17T17:11:20Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![MecatronicaMADE](https://avatars.discourse-cdn.com/v4/letter/m/ce7236/32.png) [@MecatronicaMADE](https://discourse.nodered.org/u/MecatronicaMADE)\
**Post date:** [18 February 2023 00:48 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359/6 "2023-02-18T00:48:08Z")

</div>

Si puedes darle el formato correcto a tu archivo JSON quizás pueda replicarlo.  
El nodo que estás utilizando a que módulo npm pertenece?  
Será este? -\> [azure-sql](https://flows.nodered.org/node/node-red-contrib-azure-sql)

Si es el anterior, quizás el formato que estás utilizando en tu nodo inject no sea el correcto, intenta este flujo que te comparto, configurando tus parámetros en el nodo AzureSQL, quizá te pueda ayudar.

```auto
[{"id":"2e29ce258df0786a","type":"tab","label":"Flow 28","disabled":false,"info":"","env":[]},{"id":"18350203c7b5adee","type":"Azure SQL","z":"2e29ce258df0786a","name":"Azure SQL","credentials":{"password":""},"x":790,"y":260,"wires":[["b6064efffb2f25b5"]]},{"id":"91727598cdf2f113","type":"inject","z":"2e29ce258df0786a","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{ \"action\": \"I\", \"query\": \"insert into table (Name, LastName, Age) VALUES ('Jane', 'Doe', '25')\" }","payloadType":"json","x":530,"y":260,"wires":[["5177c37f3cd0e907"]]},{"id":"b6064efffb2f25b5","type":"debug","z":"2e29ce258df0786a","name":"debug 71","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":940,"y":260,"wires":[]},{"id":"5177c37f3cd0e907","type":"json","z":"2e29ce258df0786a","name":"","property":"payload","action":"obj","pretty":false,"x":650,"y":260,"wires":[["18350203c7b5adee"]]}]

```

Tambien quizás este hilo pueda ayudarte:

> [@Node-red to azure sql](https://discourse.nodered.org/t/node-red-to-azure-sql/47896/2):
>
> node-red-contrib-mssql-plus can write to azure sql. Check out the [read me](https://flows.nodered.org/node/node-red-contrib-mssql-plus) and the built-in help after you install it.

---

_[View the full topic](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359)._