locked
Disabled SHA - error occurred during the login process RRS feed

  • Question

  • I'm trying to disabled SHA hashes using NARTAC tool but this cause the website to break. I suspects there is something wrong with the SQL server that doesnt support the "disabled SHA".

    Sharing to you the Stack Trace. Can you help check on this? What is the issue Im encountering and how to fix it.

    Server Error in '/' Application.

    An existing connection was forcibly closed by the remote host
    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.ComponentModel.Win32Exception: An existing connection was forcibly closed by the remote host

    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:



    [Win32Exception (0x80004005): An existing connection was forcibly closed by the remote host]

    [SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)]
       System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +356
       System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +117
       System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +267
       System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +318
       System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +211
       System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +393
       System.Data.SqlClient.SqlConnection.Open() +122
       Sitecore.Data.DataProviders.Sql.DataProviderCommand..ctor(IDbCommand command, DataProviderTransaction transaction, Boolean openConnection) +106
       Sitecore.Data.DataProviders.Sql.<>c__DisplayClass4.<CreateCommand>b__3() +48
       Sitecore.Data.DataProviders.NullRetryer.Execute(Func`1 action, Action recover) +289
       Sitecore.Data.DataProviders.Sql.<>c__DisplayClass12.<CreateReader>b__10() +30
       Sitecore.Data.DataProviders.NullRetryer.Execute(Func`1 action, Action recover) +289
       Sitecore.Data.DataProviders.Sql.SqlDataApi.CreateReader(String sql, Object[] parameters) +251
       Sitecore.Data.DataProviders.Sql.SqlDataProvider.GetContentLanguages() +190
       Sitecore.Data.DataProviders.Sql.SqlDataProvider.LoadLanguages() +146
       Sitecore.Data.DataProviders.Sql.SqlDataProvider.GetLanguages() +48
       Sitecore.Data.SqlServer.SqlServerDataProvider.LoadItemDefinitions(String condition, Object[] parameters, SafeDictionary`2 prefetchData) +1338
       Sitecore.Data.DataProviders.Sql.SqlDataProvider.PrefetchItems(String itemCondition, String fieldCondition, String childCondition, Object[] parameters) +147
       Sitecore.Data.DataProviders.Sql.SqlDataProvider.EnsureInitialPrefetch() +255
       Sitecore.Data.DataProviders.Sql.SqlDataProvider.GetPrefetchData(ID itemId) +44
       Sitecore.Data.DataProviders.Sql.SqlDataProvider.GetItemDefinition(ID itemId, CallContext context) +9
       Sitecore.Data.DataProviders.DataProvider.GetItemDefinition(ID itemID, CallContext context, DataProviderCollection providers) +148
       Sitecore.Data.DataSource.GetItemInformation(ID itemID) +88
       Sitecore.Data.DataSource.GetItemData(ID itemID, Language language, Version version) +31
       Sitecore.Nexus.Data.DataCommands.GetItemCommand.GetItem(ID ƒ, Language „, Version , Database ) +92
       Sitecore.Nexus.Data.DataCommands.GetItemCommand.Execute(ID ƒ, Language „, Version , Database ) +496
       Sitecore.Data.Engines.DataCommands.GetItemCommand.DoExecute() +139
       Sitecore.Data.Engines.EngineCommand`2.Execute() +96
       Sitecore.Data.Managers.ItemProvider.GetItem(ID itemId, Language language, Version version, Database database) +292
       Deltekcom.Sc.Cms.Pipelines.ItemProviders.ItemProvider.GetItem(ID itemId, Language language, Version version, Database database) in C:\TeamCity\buildAgent\work\9bf9b9dbfcd6ebf0\src\Deltekcom.Sc.Cms\Pipelines\ItemProviders\ItemProvider.cs:20
       Sitecore.Data.Managers.ItemProvider.GetItem(ID itemId, Language language, Version version, Database database, SecurityCheck securityCheck) +141
       Deltekcom.Sc.Cms.Pipelines.ItemProviders.ItemProvider.GetItem(ID itemId, Language language, Version version, Database database, SecurityCheck securityCheck) in C:\TeamCity\buildAgent\work\9bf9b9dbfcd6ebf0\src\Deltekcom.Sc.Cms\Pipelines\ItemProviders\ItemProvider.cs:41
       Deltekcom.Sc.Cms.Pipelines.ItemProviders.ItemProvider.GetItem(String itemPath, Language language, Version version, Database database, SecurityCheck securityCheck) in C:\TeamCity\buildAgent\work\9bf9b9dbfcd6ebf0\src\Deltekcom.Sc.Cms\Pipelines\ItemProviders\ItemProvider.cs:62
       Sitecore.ContentTesting.Pipelines.ItemProvider.GetItem.GetItemUnderTestProcessor.Process(GetItemArgs args) +127
       (Object , Object[] ) +74
       Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +331
       Sitecore.Data.Managers.PipelineBasedItemProvider.ExecuteAndReturnResult(String pipelineName, String pipelineDomain, Func`1 pipelineArgsCreator, Func`1 fallbackResult) +58
       Sitecore.Data.Managers.ItemManager.GetItem(String itemPath, Language language, Version version, Database database) +142
       Sitecore.FXM.Matchers.DomainMatcherRepository.GetAllDomainMatchers(IDatabase database) +81
       Sitecore.FXM.Sites.FxmSiteProvider.GetFxmSites() +94
       Sitecore.FXM.Sites.FxmSiteProvider.get_FxmSites() +103
       Sitecore.FXM.Sites.FxmSiteProvider.GetSites() +88
       System.Linq.<SelectManyIterator>d__16`2.MoveNext() +293
       Sitecore.Sites.SiteCollection.AddRange(IEnumerable`1 sites) +138
       Sitecore.Sites.SitecoreSiteProvider.GetSites() +245
       Sitecore.Sites.SiteContextFactory.GetSites() +256
       Sitecore.Sites.SiteContextFactory.GetSiteContext(String hostName, String fullPath, Int32 portNumber) +121
       Sitecore.Pipelines.HttpRequest.SiteResolver.ResolveSiteContext(HttpRequestArgs args) +430
       Sitecore.Pipelines.HttpRequest.SiteResolver.Process(HttpRequestArgs args) +50
       (Object , Object[] ) +74
       Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +331
       Sitecore.Nexus.Web.HttpModule.(Object , EventArgs ) +505
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +142
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +92

     


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.1069.1 

    Saturday, February 13, 2016 2:21 AM

Answers

  • Have you checked the SQL Server error log whether there is anything interesting that is produced when you get these login failure?

    What you mean with "disabled SHA" I have no idea. Maybe this relates TLS 1.0 vs TLS 1.2? In that cases, Microsoft announced upgrades for SQL 2008 and up and supports TLS 1.2.

    Saturday, February 13, 2016 10:21 AM