Out of nowhere users are unable to sign into the Forms system and are receiving the following message "domain/username is not a read/write named user." Even our service account is getting this message when trying to sign into the system. Everything was working fine before today.
I saw this same issue on another question but their seemed to be no answer provided. The only response related to whether or not LFDS or Repository is being used for authentication, in our case LFDS is being used. I have checked event viewer for the Forms server and the only message from today is related to the SQL & forms connection :
Log Name: Laserfiche-Forms-App/Admin
Source: Laserfiche-Forms-App
Date: 7/20/2019 4:42:25 AM
Event ID: 10018
Task Category: EntityFrameworkInaccessibleErrorAdmin
Level: Error
Keywords: Session0,Session1,Session2,Session3
User: RISOFFICE\svc_admin_laserfiche
Computer: NCTWEB16.nctcog.dst.tx.us
Description:
Entity Framework returned the following error when trying to communicate with SQL Server: The underlying provider failed on Open.. [LFF18-EntityFrameworkInaccessible]
Details:
URL:
Error: EntityFrameworkInaccessible
Date: 7/20/2019 4:42:25 AM (Central Standard Time)
HTTP Status Code: 500
Business Process ID: 0
Business Process Name:
Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: Entity Framework returned the following error when trying to communicate with SQL Server: The underlying provider failed on Open.. [LFF18-EntityFrameworkInaccessible]
Inner exception: System.Data.Entity.Core.EntityException
Message: The underlying provider failed on Open.
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
at System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at Laserfiche.Forms.Routing.RoutingEngineService.RunRouting(RoutingRequestParameters requestParam)
at Laserfiche.Forms.Routing.RoutingEngineService.<>c__DisplayClass6_0.<StartRouting_Async>b__0()
Inner exception: System.Data.SqlClient.SqlException
Message: 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.)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, 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.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
at System.Data.Entity.Infrastructure.DbExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()
at System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
Inner exception: System.ComponentModel.Win32Exception
Message: An existing connection was forcibly closed by the remote host
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Laserfiche-Forms-App" Guid="{98141CA4-660B-51C6-66B4-EC37F5B2FD87}" />
<EventID>10018</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>55516</Task>
<Opcode>0</Opcode>
<Keywords>0x4000f00000000000</Keywords>
<TimeCreated SystemTime="2019-07-20T09:42:25.754572700Z" />
<EventRecordID>5818128</EventRecordID>
<Correlation />
<Execution ProcessID="1768" ThreadID="5672" />
<Channel>Laserfiche-Forms-App/Admin</Channel>
<Computer>NCTWEB16.nctcog.dst.tx.us</Computer>
<Security UserID="S-1-5-21-2015567608-1236798086-1458450816-45271" />
</System>
<EventData>
<Data Name="message">Entity Framework returned the following error when trying to communicate with SQL Server: The underlying provider failed on Open.. [LFF18-EntityFrameworkInaccessible]
Details:
URL:
Error: EntityFrameworkInaccessible
Date: 7/20/2019 4:42:25 AM (Central Standard Time)
HTTP Status Code: 500
Business Process ID: 0
Business Process Name:
Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: Entity Framework returned the following error when trying to communicate with SQL Server: The underlying provider failed on Open.. [LFF18-EntityFrameworkInaccessible]
Inner exception: System.Data.Entity.Core.EntityException
Message: The underlying provider failed on Open.
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
at System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at Laserfiche.Forms.Routing.RoutingEngineService.RunRouting(RoutingRequestParameters requestParam)
at Laserfiche.Forms.Routing.RoutingEngineService.<>c__DisplayClass6_0.<StartRouting_Async>b__0()
Inner exception: System.Data.SqlClient.SqlException
Message: 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.)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, 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.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
at System.Data.Entity.Infrastructure.DbExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()
at System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
Inner exception: System.ComponentModel.Win32Exception
Message: An existing connection was forcibly closed by the remote host
</Data>
</EventData>
</Event>