System.Exception: Query Failed, SQL:SELECT
sc.[ShopID] AS [ShopID]
,sc.[Group] AS [Group]
,sc.[Key] AS [Key]
,sc.[Value] AS [Value]
,sc.[Type] AS [Type]
,sc.[Description] AS [Description]
,sc.[SortOrder] AS [SortOrder]
,sc.[Enable] AS [Enabled]
FROM [evision.SiteConfig] AS sc WITH (NOLOCK)
WHERE sc.[ShopID] = ''
AND sc.[Group] = 'Session'
AND sc.[Key] = 'ExpiresMinutes'
---> System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'sa'.
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.Open()
at evision.ecommerce.Common.DataStore.Query(Int32 lFromItem, Int32 lToItem) in C:\Projects\abc-bolte\src\evision.ecommerce\Common\DataStore.cs:line 1563
ClientConnectionId:5f893a3a-d1c9-4787-a70d-3cce5ec307d9
Error Number:18456,State:1,Class:14
--- End of inner exception stack trace ---
at evision.ecommerce.Common.DataStore.Query(Int32 lFromItem, Int32 lToItem) in C:\Projects\abc-bolte\src\evision.ecommerce\Common\DataStore.cs:line 1600
at evision.ecommerce.Common.LogicUnit.DataQuery.Query[T](Int32 pFromItem, Int32 pToItem, Boolean pRunNestedQuery) in C:\Projects\abc-bolte\src\evision.ecommerce\Common\LogicUnit\DataQuery.cs:line 785
at evision.ecommerce.Common.LogicUnit.Settings.Get[T](String pShopID, String pGroupID, String pKey) in C:\Projects\abc-bolte\src\evision.ecommerce\Common\LogicUnit\Settings.cs:line 112
at evision.ecommerce.Common.LogicUnit.Session.AutoLoadFromCookie() in C:\Projects\abc-bolte\src\evision.ecommerce\Common\LogicUnit\Session.cs:line 1085
at evision.ecommerce.Common.LogicUnit.Session.GetValue(String pKey) in C:\Projects\abc-bolte\src\evision.ecommerce\Common\LogicUnit\Session.cs:line 164
at evision.ecommerce.Common.LogicUnit.Session.get_UseCache() in C:\Projects\abc-bolte\src\evision.ecommerce\Common\LogicUnit\Session.cs:line 885
at evision.ecommerce.Inventory.Provider.Product.GetProductCountByCategoryID(String pCategoryID) in C:\Projects\abc-bolte\src\evision.ecommerce\Inventory\Provider\Product.cs:line 358
at Electronics.ClassLib.Controllers.Common.CategoryViewComponent.GetCategoryModel(String pID, Int32 rootid) in C:\Projects\abc-bolte\src\evision.Core\ViewComponents\CategoryViewComponent.cs:line 143
at Electronics.ClassLib.Controllers.Common.CategoryViewComponent.InvokeAsync(String pID, Int32 rootID) in C:\Projects\abc-bolte\src\evision.Core\ViewComponents\CategoryViewComponent.cs:line 43
at Microsoft.AspNetCore.Mvc.ViewComponents.DefaultViewComponentInvoker.InvokeAsyncCore(ObjectMethodExecutor executor, Object component, ViewComponentContext context)
at Microsoft.AspNetCore.Mvc.ViewComponents.DefaultViewComponentInvoker.InvokeAsync(ViewComponentContext context)
at Microsoft.AspNetCore.Mvc.ViewComponents.DefaultViewComponentInvoker.InvokeAsync(ViewComponentContext context)
at Microsoft.AspNetCore.Mvc.ViewComponents.DefaultViewComponentHelper.InvokeCoreAsync(ViewComponentDescriptor descriptor, Object arguments)
at AspNetCore.Views_CategoryPage.ExecuteAsync() in C:\Kunder\ABCBolte\Views\CategoryPage.cshtml:line 41