# Set dynamic password for MSSQL node

**URL:** <https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082>\
**Category:** General\
**Created:** [6 July 2021 09:35 UTC](https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082 "2021-07-06T09:35:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sathishkumarc14](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@sathishkumarc14](https://discourse.nodered.org/u/sathishkumarc14)\
**Post date:** [6 July 2021 09:35 UTC](https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082/1 "2021-07-06T09:35:11Z")

</div>

How to set dynamic user name and password for MSSQL PLUS CN NODE? Is there any possibility?

Whenever new deployment happens, we have to update the user name and password for database node.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [6 July 2021 10:41 UTC](https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082/2 "2021-07-06T10:41:52Z")

</div>

For now, you can only use Env Vars e.g. `${SQL_PASS}`

---

<div class="post-metadata">

**Author:** ![Marvin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marvin/32/44846_2.png) [@Marvin](https://discourse.nodered.org/u/Marvin)\
**Post date:** [13 July 2021 05:39 UTC](https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082/3 "2021-07-13T05:39:14Z")

</div>

Hi, Steve  
Does it support to set user name by env var?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [13 July 2021 06:08 UTC](https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082/4 "2021-07-13T06:08:40Z")

</div>

Should do.

---

<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:** [11 September 2021 06:09 UTC](https://discourse.nodered.org/t/set-dynamic-password-for-mssql-node/48082/5 "2021-09-11T06:09:25Z")

</div>

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