Last post Jan 15, 2019 04:47 AM by wmec
Jan 14, 2019 06:47 AM|callykalpana|LINK
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 )
Jan 15, 2019 04:47 AM|wmec|LINK
Try to handle Stored proc, within SQL server management studio.