Click here to Skip to main content
12,815,929 members (38,663 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#2.0 C# SQL

My Webservices connects to database. It works perfectly on my local computer, but when uploaded to the server it doesn't work. Below is the error message:

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: The stored procedure 'DropDownList_PackagesByMagID' doesn't exist.

This happens only for Newly created stored procedures but for Old stored procedures works fine on the same database

Can somebody please tell me how I can fix it?

Posted 3-Oct-11 4:23am
Updated 3-Oct-11 4:27am
Mehdi Gholam 3-Oct-11 9:44am
First make sure the sp exists on the server.
Bala Selvanayagam 3-Oct-11 9:49am
New sps could be in a different schema?
Rate this: bad
Please Sign up or sign in to vote.

Solution 1


I think you should review your SQL objects list one more time with considering SQL Server security issues. For example, schema, user_id you are using has the proper permission etc.

Md. Marufuzzaman
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


I'm able to run webservices for already existing stored procedures for the same database, Its not working for new
stored procedures which i created.

Also till Friday new stored procedures was working fine. But today when I tried to run my application it threw above error. There was no code change.

My application connects to web-service which connects to database to get data.

Considering security issue then it should not have allowed any stored procedures to execute,

Bala Selvanayagam 3-Oct-11 11:51am
Are you pointed to the right database ? perhaps your source is pointed to a test bed where the stored procedure is not there ?
Achuki Bhalotia 5-Oct-11 1:38am
Hi Bala,

All my stored procedures are in same database and only one connection string is used to connect.

Sp exists on the database and are in same schema as other sp's.

Also to highlisht everything was working fine but it stopped working for new stored proc without any change in code.

Please help.


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170308.1 | Last Updated 3 Oct 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100