# Mssql conection dynamic inputs

**URL:** <https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544>\
**Category:** General\
**Created:** [28 November 2019 10:39 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544 "2019-11-28T10:39:43Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![DemonKing](https://avatars.discourse-cdn.com/v4/letter/d/b4bc9f/32.png) [@DemonKing](https://discourse.nodered.org/u/DemonKing)\
**Post date:** [28 November 2019 10:39 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/1 "2019-11-28T10:39:43Z")

</div>

![IMG_20191128_160500](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/b/bff1f6e225bc4e295b2db79d2768b7072f8c340a.jpeg)

```auto
i tried {{flow.ipaddess}} on the server field its not working. please help me to find a solution for this

```

---

<div class="post-metadata">

**Author:** ![ghayne](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ghayne/32/39_2.png) [@ghayne](https://discourse.nodered.org/u/ghayne)\
**Post date:** [28 November 2019 10:46 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/2 "2019-11-28T10:46:56Z")

</div>

I'm pretty sure you have to enter the actual server name or IP.

---

<div class="post-metadata">

**Author:** ![DemonKing](https://avatars.discourse-cdn.com/v4/letter/d/b4bc9f/32.png) [@DemonKing](https://discourse.nodered.org/u/DemonKing)\
**Post date:** [28 November 2019 10:54 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/3 "2019-11-28T10:54:07Z")

</div>

ha ha leave ip i tried give others static and try the same method to database name now same error came .. i am very sure the DB name.. if i give all static it conected perfectly..  
so i want to know hjow to pass variables dynamic between nodes

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [28 November 2019 10:55 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/4 "2019-11-28T10:55:26Z")

</div>

@DemonKing it will depend on what the particular node supports. Check its documentation to see what it says you can do.

What node is it? Which module did you install to get it?

---

<div class="post-metadata">

**Author:** ![DemonKing](https://avatars.discourse-cdn.com/v4/letter/d/b4bc9f/32.png) [@DemonKing](https://discourse.nodered.org/u/DemonKing)\
**Post date:** [28 November 2019 11:06 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/5 "2019-11-28T11:06:28Z")

</div>

its mustache format {{{payload.name}}} i can used this in querys thats working fine.

but cant use same thing in conections

and that node is : node-red-contrib-mssql

pls find me the solution

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [28 November 2019 11:08 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/6 "2019-11-28T11:08:56Z")

</div>

It does not look like that node supports dynamically changing the connection details. You will have to look for a different node - there are a few on [flows.nodered.org](http://flows.nodered.org) for MSSql - one of them might let you do what you are trying to do.

---

<div class="post-metadata">

**Author:** ![DemonKing](https://avatars.discourse-cdn.com/v4/letter/d/b4bc9f/32.png) [@DemonKing](https://discourse.nodered.org/u/DemonKing)\
**Post date:** [28 November 2019 11:11 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/7 "2019-11-28T11:11:56Z")

</div>

ok and thanks,  
could you suggeset me for the dynamic conection change node pls

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [28 November 2019 11:12 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/8 "2019-11-28T11:12:30Z")

</div>

No, I don't use MSSQL. You'll have to investigate the nodes yourself.

---

<div class="post-metadata">

**Author:** ![DemonKing](https://avatars.discourse-cdn.com/v4/letter/d/b4bc9f/32.png) [@DemonKing](https://discourse.nodered.org/u/DemonKing)\
**Post date:** [28 November 2019 11:15 UTC](https://discourse.nodered.org/t/mssql-conection-dynamic-inputs/18544/9 "2019-11-28T11:15:58Z")

</div>

ok and thanks