# Connecting to MSSQL error

**URL:** <https://discourse.nodered.org/t/connecting-to-mssql-error/94964>\
**Category:** General\
**Created:** [28 January 2025 18:25 UTC](https://discourse.nodered.org/t/connecting-to-mssql-error/94964 "2025-01-28T18:25:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rbmgf7](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@rbmgf7](https://discourse.nodered.org/u/rbmgf7)\
**Post date:** [28 January 2025 18:25 UTC](https://discourse.nodered.org/t/connecting-to-mssql-error/94964/1 "2025-01-28T18:25:28Z")

</div>

![Screenshot 2025-01-28 121826](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/e/8ede344e5a62c677e3f0c6fc55b71a68f8a1b40c.png)  
 ![Screenshot 2025-01-28 121756](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/e/9ea8f73f1be9290f305091cbd16271807ea29c7e.png)  
 ![Screenshot 2025-01-28 122352](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/b/9bad65aa65843406dcc5908f06e3faff1b16a3b5.png)

I'm trying to connect NR to our companies MSSQL server. I've been trying to work with the database team but we can't seem to get it to work. I used my Microsoft Authentication for my account and the DB team made a general login for me and I can't get it to connect apparently.

I tried injecting a SQL query but I just get a bunch of undefined and the error in the cmd window.

Any suggestions? I tried some other MSSQL pallets and some other ones will stop NR and then I have to restart it.

---

<div class="post-metadata">

**Author:** ![rbmgf7](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@rbmgf7](https://discourse.nodered.org/u/rbmgf7)\
**Post date:** [28 January 2025 18:53 UTC](https://discourse.nodered.org/t/connecting-to-mssql-error/94964/2 "2025-01-28T18:53:01Z")

</div>

Had to:

> npm install mssql

Then everything worked. Still issues querying but at least I'm logged into the server.

---

<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:** [28 January 2025 20:58 UTC](https://discourse.nodered.org/t/connecting-to-mssql-error/94964/3 "2025-01-28T20:58:48Z")

</div>

that should not be necessary.

Do you have more than one MSSQL contrib package installed?

---

<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 February 2025 20:58 UTC](https://discourse.nodered.org/t/connecting-to-mssql-error/94964/4 "2025-02-11T20:58:50Z")

</div>

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