# MSSQL-Plus cannot find my Stored Procedure :-(

**URL:** https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071
**Category:** General
**Tags:** database
**Created:** [17 March 2025 14:49 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071 "2025-03-17T14:49:49Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![DesP](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@DesP](https://discourse.nodered.org/u/DesP)
#### Post date: [17 March 2025 14:49 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071/1 "2025-03-17T14:49:49Z")

</div>

Hi All,

As per the title, I am getting the following error:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/5/95f92c4bb1992baf8d1310ab193297f854c38bab.png)

The node is configured like this:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/f/5f25bfc68733fd1c28ed4a43fc780099898fc3ac.png)

My stored procedure (usp\_My\_Insert) is in the "Stored Procedures" folder in SQL Server. It works fine on the server.

The connection node used in this flow works fine for other SQL tasks.

All thoughts appreciated 😀

---

<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: [17 March 2025 15:08 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071/2 "2025-03-17T15:08:01Z")

</div>

try prefixing it with `dbo.` (or whatever schema it belongs to)

It could also be a permission issue (does the account setup on the config have EXECUTE permissions on the stored procedure?)

---

<div class="post-metadata">

### Author: ![DesP](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@DesP](https://discourse.nodered.org/u/DesP)
#### Post date: [17 March 2025 15:34 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071/3 "2025-03-17T15:34:38Z")

</div>

Hi Steve,

I have tried with and without the "dbo." with no success.

The permissions are as this:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/9/d9616c171a2b661f8c3a5b01efbf818798bc1c03.png)

Any further thoughts?

---

<div class="post-metadata">

### Author: ![DesP](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@DesP](https://discourse.nodered.org/u/DesP)
#### Post date: [17 March 2025 16:29 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071/4 "2025-03-17T16:29:58Z")

</div>

Just for completeness:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/5/8575cfd2a55d3dfe441923d7642d9f58892c7df5.png)

---

<div class="post-metadata">

### Author: ![kitori](https://avatars.discourse-cdn.com/v4/letter/k/f08c70/32.png) [@kitori](https://discourse.nodered.org/u/kitori)
#### Post date: [18 March 2025 07:36 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071/5 "2025-03-18T07:36:56Z")

</div>

If i call a mssql sp from node-red, i use the scheme (with brackets!)  
[dbname].[schema].[uspname]

Have you tried this?

---

<div class="post-metadata">

### Author: ![DesP](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@DesP](https://discourse.nodered.org/u/DesP)
#### Post date: [18 March 2025 11:07 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071/6 "2025-03-18T11:07:35Z")

</div>

@kitori Perfect! That worked straight away 😄

For interest the SQL User Account has access to multiple databases, so thinking about it, your fix probably makes perfect sense 👍

Thanks to all.

---

<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: [1 April 2025 11:08 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071/7 "2025-04-01T11:08:26Z")

</div>

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