# MSSQL Windows Autentication

**URL:** <https://discourse.nodered.org/t/mssql-windows-autentication/9779>\
**Category:** General\
**Created:** [4 April 2019 19:56 UTC](https://discourse.nodered.org/t/mssql-windows-autentication/9779 "2019-04-04T19:56:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mario](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@Mario](https://discourse.nodered.org/u/Mario)\
**Post date:** [4 April 2019 19:56 UTC](https://discourse.nodered.org/t/mssql-windows-autentication/9779/1 "2019-04-04T19:56:42Z")

</div>

Hallo,

First of all...sorry for my bad english but i will try my best.

I‘ll try to commit on a MSSQL Database. But was i found is with Server Autentication. But i Need Windows Autentication. Is there an example of what shows me how to do it?

---

<div class="post-metadata">

**Author:** ![TheSauce](https://avatars.discourse-cdn.com/v4/letter/t/3bc359/32.png) [@TheSauce](https://discourse.nodered.org/u/TheSauce)\
**Post date:** [5 April 2019 16:40 UTC](https://discourse.nodered.org/t/mssql-windows-autentication/9779/2 "2019-04-05T16:40:46Z")

</div>

I am using Windows Authentication with my connection. In the settings in the [MSSQL](https://flows.nodered.org/node/node-red-contrib-mssql) node, set the Domain to be either the hostname of your SQL server (if not joined to a domain) or the actual domain it is joined to. In the case below, JMT-XPCO is the hostname of the machine running SQL Server.

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/9/98e6523cab8b619ddbe8637451689e1005ed6381.png)

---

<div class="post-metadata">

**Author:** ![Mario](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@Mario](https://discourse.nodered.org/u/Mario)\
**Post date:** [7 April 2019 09:11 UTC](https://discourse.nodered.org/t/mssql-windows-autentication/9779/3 "2019-04-07T09:11:14Z")

</div>

Hallo,

Thanks for your answer. I‘ll try it tomorow at work.

---

<div class="post-metadata">

**Author:** ![Mario](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@Mario](https://discourse.nodered.org/u/Mario)\
**Post date:** [8 April 2019 07:16 UTC](https://discourse.nodered.org/t/mssql-windows-autentication/9779/4 "2019-04-08T07:16:41Z")

</div>

I tried. Unfortunately, the registration comes from the AD. Therefore, my login with username and password will be rejected.