Application does no longer see the SQL stored procedures
Posted on 2008-11-12
I support the C# 2008 web application, SQL 2005. The web service uses the service account to talk to the database. Suddenly, literally overnight, we started getting the error : "Exception Message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: The stored procedure 'XXXX' doesn't exist." launching the app. It can't find any of the stored procs, even though they exist in the database and the service account role's permissions haven't changed (from what we were told). It doesn't have the db_owner authority but whatever access was given has always worked before. The problem occurs in all environments including my local. When I debug it fails at the function below, line : parameterCache.SetParameters(objdbCommand, objDatabase);
public static void DiscoverSpInputParameters(SqlDatabase objDatabase, DbCommand objdbCommand)
foreach (DbParameter param in objdbCommand.Parameters)
if (param.Direction == ParameterDirection.ReturnValue)
It's a puzzle, since nothing was changed on the developer's side, the function has worked for years, first in VS 2005. My feeling is that something got changed on the SQL server/database side but our DBA's say that nothing was changed. Any input/suggestions/ideas would be greately appreciated!