Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 years ago
Hi!
First of all thanks for the support.
I was having problems with the shop because of the .NET version, i set it up to 4 in the app pool and the error changed to this one:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

The connections string is OK but i think the application is not reading the connection string, i have test placing the strings of the connections string file in the web config and still the same.
The settings are alright in the connection string so i cannot imagine why is not working!!

Please some help would be very appreciated.
Thanks so much in advance.
13 years ago
Last provlem solved adding manually the connection strings in the IIS, but now it seems that some tables were not created and i am getting this error if i click on a product of the example home page

Server Error in '/shop' Application.

Could not find stored procedure 'dbo.Nop_ProductLoadAllPaged'.

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 'dbo.Nop_ProductLoadAllPaged'.

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 'dbo.Nop_ProductLoadAllPaged'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +58
   System.Data.SqlClient.SqlDataReader.get_MetaData() +118
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6312385
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6313986
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +256
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
   System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +617

[EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.]
   System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +10507576
   System.Data.Objects.ObjectContext.CreateFunctionObjectResult(EntityCommand entityCommand, EntitySet entitySet, EdmType edmType, MergeOption mergeOption) +4485738
   System.Data.Objects.ObjectContext.ExecuteFunction(String functionName, MergeOption mergeOption, ObjectParameter[] parameters) +239
   System.Data.Objects.ObjectContext.ExecuteFunction(String functionName, ObjectParameter[] parameters) +78
   NopSolutions.NopCommerce.BusinessLogic.Data.NopObjectContext.Sp_ProductLoadAllPaged(Nullable`1 categoryID, Nullable`1 manufacturerID, Nullable`1 productTagID, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, Nullable`1 relatedToProductID, String keywords, Nullable`1 searchDescriptions, Nullable`1 showHidden, Nullable`1 pageIndex, Nullable`1 pageSize, String filteredSpecs, Nullable`1 languageID, Nullable`1 orderBy, ObjectParameter totalRecords) in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Data\NopObjectContext.Functions.cs:554
   NopSolutions.NopCommerce.BusinessLogic.Products.ProductService.GetAllProducts(Int32 categoryId, Int32 manufacturerId, Int32 productTagId, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, Int32 relatedToProductId, String keywords, Boolean searchDescriptions, Int32 pageSize, Int32 pageIndex, List`1 filteredSpecs, Int32 languageId, ProductSortingEnum orderBy, Int32& totalRecords) in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Products\ProductService.cs:386
   NopSolutions.NopCommerce.BusinessLogic.Products.ProductService.GetAllProducts(Int32 categoryId, Int32 manufacturerId, Int32 productTagId, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, String keywords, Boolean searchDescriptions, Int32 pageSize, Int32 pageIndex, List`1 filteredSpecs, ProductSortingEnum orderBy, Int32& totalRecords) in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Products\ProductService.cs:293
   NopSolutions.NopCommerce.BusinessLogic.Products.ProductService.GetAllProducts(Int32 categoryId, Int32 manufacturerId, Int32 productTagId, Nullable`1 featuredProducts, Int32 pageSize, Int32 pageIndex, Int32& totalRecords) in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Products\ProductService.cs:167
   NopSolutions.NopCommerce.BusinessLogic.Categories.Category.get_FeaturedProducts() in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Categories\Category.cs:402
   NopSolutions.NopCommerce.Web.Templates.Categories.ProductsInGrid.BindData() in C:\tfs.4pm.ie\Third Party\EcommerceStore\NopCommerceStore\Templates\Categories\ProductsInGrid.ascx.cs:95
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.UI.Control.LoadRecursive() +71
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3048
13 years ago
Solved exoporting again all stored procedures.
Now i an getting another error, please all help will be much appreciated.
This is the error:

Server Error in '/shop' Application.

Cannot insert the value NULL into column 'CustomerID', table 'ecommerce_db.dbo.Nop_Customer'; column does not allow nulls. INSERT fails.
The statement has been terminated.

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: Cannot insert the value NULL into column 'CustomerID', table 'ecommerce_db.dbo.Nop_Customer'; column does not allow nulls. INSERT fails.
The statement has been terminated.

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): Cannot insert the value NULL into column 'CustomerID', table 'ecommerce_db.dbo.Nop_Customer'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +58
   System.Data.SqlClient.SqlDataReader.get_MetaData() +118
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6312385
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6313986
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +256
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
   System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) +279
   System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +536

[UpdateException: An error occurred while updating the entries. See the inner exception for details.]
   System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +11091774
   System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) +764
   NopSolutions.NopCommerce.BusinessLogic.CustomerManagement.CustomerService.AddCustomerForced(Guid customerGuid, String email, String username, String passwordHash, String saltKey, Int32 affiliateId, Int32 billingAddressId, Int32 shippingAddressId, Int32 lastPaymentMethodId, String lastAppliedCouponCode, String giftCardCouponCodes, String checkoutAttributes, Int32 languageId, Int32 currencyId, TaxDisplayTypeEnum taxDisplayType, Boolean isTaxExempt, Boolean isAdmin, Boolean isGuest, Boolean isForumModerator, Int32 totalForumPosts, String signature, String adminComment, Boolean active, Boolean deleted, DateTime registrationDate, String timeZoneId, Int32 avatarId, Nullable`1 dateOfBirth) in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Customer\CustomerService.cs:1238
   NopSolutions.NopCommerce.BusinessLogic.CustomerManagement.CustomerService.AddCustomer(Guid customerGuid, String email, String username, String password, Int32 affiliateId, Int32 billingAddressId, Int32 shippingAddressId, Int32 lastPaymentMethodId, String lastAppliedCouponCode, String giftCardCouponCodes, String checkoutAttributes, Int32 languageId, Int32 currencyId, TaxDisplayTypeEnum taxDisplayType, Boolean isTaxExempt, Boolean isAdmin, Boolean isGuest, Boolean isForumModerator, Int32 totalForumPosts, String signature, String adminComment, Boolean active, Boolean deleted, DateTime registrationDate, String timeZoneId, Int32 avatarId, Nullable`1 dateOfBirth, MembershipCreateStatus& status) in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Customer\CustomerService.cs:1102
   NopSolutions.NopCommerce.BusinessLogic.CustomerManagement.CustomerService.AddCustomer(String email, String username, String password, Boolean isAdmin, Boolean isGuest, Boolean active, MembershipCreateStatus& status) in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Customer\CustomerService.cs:938
   NopSolutions.NopCommerce.BusinessLogic.Profile.StoreMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) in C:\tfs.4pm.ie\Third Party\EcommerceStore\Libraries\Nop.BusinessLogic\Profile\StoreMembershipProvider.cs:101
   System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +412
   System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +226
   System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +586
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +52
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3691

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
13 years ago
nobody???
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.