Azure SQL Database: [SqlException (0x80131904): Could not find stored procedure

0

I get the error:

Azure SQL Database: [SqlException (0x80131904): Could not find stored procedure

when I deploy my ASP.NET MVC application to azure. My database is an Azure SQL database.

The code runs fine in my development environment. The procedure belongs to a custom schema. Below is how I call the procedure from my code.

SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[schema_name].[procedure_name]";

I think it might have to do with some schema permission. I took the connection string to connect my mvc application to DB from the azure protal.

I would really appreciate any help/direction.

sql
sql-server
stored-procedures
azure-sql-database
asked on Stack Overflow Aug 18, 2020 by Ravi Kukreja • edited Aug 18, 2020 by Ravi Kukreja

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0