locked
Getting error executing stored procedure while debugging/ running on on localhost RRS feed

  • Question

  • User2015884762 posted

    Hi all

    I am getting the below error while running a web application. The web form consists of a file upload control that uploads excel file, read the cells and input them into the db. The inserting is done via stored procedure. The thing is, it was working fine until I chose to change Server Properties under the Project Properties>Web. I wanted to the debug directly on the IIS instead of using IIS Express. I was initially getting the error not being able to login, but I change the App Pool Identity to Network Service. I was getting a chain of errors like unable to run the execute or select permission which I have solved by running the query directly on SQL Server. However, I don't think running the query all the time solve the issue, how can I solve it once and for all . 

    The tblename1 is a user defined table type ( I am not really good in sql server, but I assume this was created by the stored procedure )

    Name Value Type
    ex {"The EXECUTE permission was denied on the object 'tblname1', database 'OMdb', schema 'dbo'."} System.Exception {System.Data.SqlClient.SqlException}
    Monday, January 14, 2019 6:47 AM

All replies

  • User364663285 posted

    Try to handle Stored proc, within SQL server management studio.

    Tuesday, January 15, 2019 4:47 AM