If the stored procedure was newly created odds are it needs to be granted permissions to execute for the given user Run this command GRANT EXEC ON [Stored Proc Name] TO...
If the stored procedure was newly created odds are it needs to be granted permissions to execute for the given user Run this command GRANT EXEC ON [Stored Proc Name] TO...