Could not find stored procedure 'Nop_LanguageLoadAll

All,

           I have been getting this error since i transferred the website to godaddy...its working fine on other hosting company...i don't understand why it says Procedure not found??

          Please help....

Thanks.


Could not find stored procedure 'Nop_LanguageLoadAll'.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'Nop_LanguageLoadAll'.Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'Nop_LanguageLoadAll'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1949258
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4845243
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +223
   Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +244
   NopSolutions.NopCommerce.DataAccess.Directory.SQLLanguageProvider.GetAllLanguages(Boolean showHidden) in SQLLanguageProvider.cs:91
   NopSolutions.NopCommerce.Common.Directory.LanguageManager.GetAllLanguages(Boolean showHidden) in LanguageManager.cs:135
   NopSolutions.NopCommerce.Common.Directory.LanguageManager.GetAllLanguages() in LanguageManager.cs:118
   NopSolutions.NopCommerce.Common.NopContext.get_WorkingLanguage() in NopContext.cs:339
   NopSolutions.NopCommerce.HttpModules.MembershipHttpModule.Application_BeginRequest(Object sender, EventArgs e) in MembershipHttpModule.cs:118
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Can you connect to your database and check whether "Nop_LanguageLoadAll" stored procedure exists there?

My trouble is as follows :

The EXECUTE permission was denied on the object 'Nop_SettingLoadAll', database 'banhang', schema 'dbo'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'Nop_SettingLoadAll', database 'banhang', schema 'dbo'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): The EXECUTE permission was denied on the object 'Nop_SettingLoadAll', database 'banhang', schema 'dbo'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +210
   Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +244
   NopSolutions.NopCommerce.DataAccess.Configuration.Settings.SQLSettingProvider.GetAllSettings() in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.DataAccess.SqlServer\Configuration\Settings\SQLSettingProvider.cs:129
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetAllSettings() in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:111
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingByName(String Name) in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:338
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValue(String Name) in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:306
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValueBoolean(String Name, Boolean DefaultValue) in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:239
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValueBoolean(String Name) in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:228
   NopSolutions.NopCommerce.BusinessLogic.Directory.LanguageManager.get_CacheEnabled() in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.BusinessLogic\Directory\LanguageManager.cs:197
   NopSolutions.NopCommerce.BusinessLogic.Directory.LanguageManager.GetAllLanguages(Boolean showHidden) in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.BusinessLogic\Directory\LanguageManager.cs:105
   NopSolutions.NopCommerce.BusinessLogic.NopContext.get_WorkingLanguage() in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.BusinessLogic\NopContext.cs:337
   NopSolutions.NopCommerce.HttpModules.MembershipHttpModule.Application_BeginRequest(Object sender, EventArgs e) in F:\Own\NopCommerce\Solution\Solution\Libraries\Nop.HttpModules.MembershipModule\MembershipHttpModule.cs:138
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Any help is strongly appreciated.

Permissions... what host??

http://www.google.co.nz/search?source=ig&hl=en&rlz=&q=):+The+EXECUTE+permission+was+denied+on+the+object+&btnG=Google+Search&meta=lr%3D&aq=&oq=

Thanks Skiltz. Your information is very usefull and what I found and could solve my above problem.

GRANT EXECUTE ON [InsertEmpInfo] TO [NT AUTHORITY\NETWORK SERVICE]

You may need to give asp.net user permission too... Another way is RIGHT clicking on the object(Procedure you have stored), click on PROPERTIES, browse for the ASP.NET user and check GRANT

I want to share here and hope it usefull for another...

Same problem, but example of Granding does help.

any sugestion??


Line 106:            DbCommand dbCommand = db.GetStoredProcCommand("Nop_LanguageLoadAll");
Line 107:            db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
Line 108:            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
Line 109:            {
Line 110:                while (dataReader.Read())


SqlException (0x80131904): De machtiging EXECUTE is geweigerd voor het object Nop_LanguageLoadAll, database DK_WebShop, schema dbo.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1948826
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844747
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +210
   Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +244
   NopSolutions.NopCommerce.DataAccess.Directory.SQLLanguageProvider.GetAllLanguages(Boolean showHidden) in E:\nopCommerce\Libraries\Nop.DataAccess.SqlServer\Directory\SQLLanguageProvider.cs:108
   NopSolutions.NopCommerce.BusinessLogic.Directory.LanguageManager.GetAllLanguages(Boolean showHidden) in E:\nopCommerce\Libraries\Nop.BusinessLogic\Directory\LanguageManager.cs:110
   NopSolutions.NopCommerce.BusinessLogic.NopContext.get_WorkingLanguage() in E:\nopCommerce\Libraries\Nop.BusinessLogic\NopContext.cs:337
   NopSolutions.NopCommerce.HttpModules.MembershipHttpModule.Application_BeginRequest(Object sender, EventArgs e) in E:\nopCommerce\Libraries\Nop.HttpModules.MembershipModule\MembershipHttpModule.cs:138
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75