MSSQL-Plus cannot find my Stored Procedure :-(

[DesP]

Hi All,

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

The node is configured like this:

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

[Steve-Mcl]

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?)

[DesP]

Hi Steve,

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

The permissions are as this:

Any further thoughts?

[DesP]

Just for completeness:

[kitori]

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

Have you tried this?

[DesP]

@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.