# 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:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sergiofernandez](https://avatars.discourse-cdn.com/v4/letter/s/977dab/32.png) [@sergiofernandez](https://discourse.nodered.org/u/sergiofernandez)\
**Post date:** [17 February 2023 17:11 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359/1 "2023-02-17T17:11:20Z")

</div>

Buenos días , no puedo hacer la conexión entre mi node red y azure SQL ,,alguien tiene algun tips?

---

<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:** [17 February 2023 17:36 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359/2 "2023-02-17T17:36:51Z")

</div>

Hola @sergiofernandez , bienvenido al Foro de Node-RED, podrías compartirnos tu flujo (utilizando la herramienta para compartir código en el foro) y proporcionar más contexto, esto para poder tratar de ayudar.

Saludos.

---

<div class="post-metadata">

**Author:** ![sergiofernandez](https://avatars.discourse-cdn.com/v4/letter/s/977dab/32.png) [@sergiofernandez](https://discourse.nodered.org/u/sergiofernandez)\
**Post date:** [17 February 2023 18:45 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359/3 "2023-02-17T18:45:05Z")

</div>

Hola @MecatronicaMADE gracias por tu tiempo , mira es el siguiente ,  
tengo la base creada en Azure pero no logro conexión a ella

[{"id":"7f8232640e0e74fb","type":"Azure SQL","z":"4c8c2b5ef5ae30b8","name":"isprotec","credentials":{},"x":520,"y":1900,"wires":[["8d5dda67a59ae812"]]},{"id":"f3683dccc48395ed","type":"inject","z":"4c8c2b5ef5ae30b8","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":260,"y":1980,"wires":[["7f8232640e0e74fb"]]},{"id":"8d5dda67a59ae812","type":"debug","z":"4c8c2b5ef5ae30b8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":770,"y":2000,"wires":}]

---

<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:13 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359/4 "2023-02-18T00:13:22Z")

</div>

@sergiofernandez Es importante completar todos los pasos de inicio del foro (discobot) para conocer cómo compartir correctamente tu archivo JSON en un hilo dentro del foro, ya que como lo compartiste no es posible replicarlo.

En adición:

- ¿Cuáles son los nodos que estás utilizando para conectarte con Azure SQL?
- ¿Tienes algun nodo debug conectado a la salida de este nodo?
- ¿Cuál es el error que te marca dentro del editor de flujos de Node-RED?

Recuerda que entre más información proporciones, es más probable que alguien en el foro pueda ayudarte.

---

<div class="post-metadata">

**Author:** ![sergiofernandez](https://avatars.discourse-cdn.com/v4/letter/s/977dab/32.png) [@sergiofernandez](https://discourse.nodered.org/u/sergiofernandez)\
**Post date:** [18 February 2023 00:17 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359/5 "2023-02-18T00:17:57Z")

</div>

@MecatronicaMADE , tengo un nodo Azure SQL (a secas) le tengo un debug y un injet el error que me sale es "action was not detected"

---

<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.

---

<div class="post-metadata">

**Author:** ![sergiofernandez](https://avatars.discourse-cdn.com/v4/letter/s/977dab/32.png) [@sergiofernandez](https://discourse.nodered.org/u/sergiofernandez)\
**Post date:** [22 February 2023 13:11 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359/7 "2023-02-22T13:11:46Z")

</div>

Buenos dias , eh tratado con varios nodos pero ninguno funciona al parecer no tienen acceso al server de azure , incluso trate desde otro cliente q no sea node red y tampoco entra a la bd

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [23 April 2023 13:12 UTC](https://discourse.nodered.org/t/no-puedo-conectar-azure-sql/75359/8 "2023-04-23T13:12:30Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.