# MSSQL node to be windows authentication mode

**URL:** <https://discourse.nodered.org/t/mssql-node-to-be-windows-authentication-mode/21022>\
**Category:** General\
**Created:** [30 January 2020 01:01 UTC](https://discourse.nodered.org/t/mssql-node-to-be-windows-authentication-mode/21022 "2020-01-30T01:01:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Henjoe](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henjoe/32/52335_2.png) [@Henjoe](https://discourse.nodered.org/u/Henjoe)\
**Post date:** [30 January 2020 01:01 UTC](https://discourse.nodered.org/t/mssql-node-to-be-windows-authentication-mode/21022/1 "2020-01-30T01:01:51Z")

</div>

Dear all, is it possible with node-contrib-mssql node to be connected to an SQL server via Windows Authentication Mode? What I want is to not give any user and password on the node, but rather is, it automatically use the current login user of the PC. Is this possible?  
Thank you, folks!

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [30 January 2020 06:34 UTC](https://discourse.nodered.org/t/mssql-node-to-be-windows-authentication-mode/21022/2 "2020-01-30T06:34:12Z")

</div>

The node uses this npm module: [https://www.npmjs.com/package/mssql](https://www.npmjs.com/package/mssql)

The module's readme suggests, that generally, it supports two different "drivers" to connect with the server, Tedious and a native driver from Microsoft. That native one _seems_ to support Windows authentication. But neither the driver nor the authentication mode are exposed in the contrib node.

So the answer would be no.

---

<div class="post-metadata">

**Author:** ![Henjoe](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henjoe/32/52335_2.png) [@Henjoe](https://discourse.nodered.org/u/Henjoe)\
**Post date:** [30 January 2020 06:37 UTC](https://discourse.nodered.org/t/mssql-node-to-be-windows-authentication-mode/21022/3 "2020-01-30T06:37:49Z")

</div>

Thanks for prompt answer my friend!

Regards,

---

<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:** [30 March 2020 06:37 UTC](https://discourse.nodered.org/t/mssql-node-to-be-windows-authentication-mode/21022/4 "2020-03-30T06:37:52Z")

</div>

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