You are viewing limited content. For full access, please sign in.

Question

Question

Unable to Log In to Forms Site

Forms
Updated July 20, 2019
asked on May 4, 2018

I was able to log in to the forms site as the same user yesterday but today I am not able to.  I am getting the message that the user "is not a read/write named user".  I verified that the account has read and write access to the forms site in LDFS but I am still having trouble logging in today.  

1 0

Replies

replied on May 6, 2018

Hi Dane,

Are you using LFDS authentication or repository authentication on Forms?

If you are using LFDS authentication, there won't be error like "is not a read/write named user"; instead, you would always be able to login but see error like "You are not licensed for Laserfiche Forms. Please contact your system administrator for more information." after you login.

Error like "is not a read/write named user" only shows when Forms uses repository authentication. In this case the account rights on LFDS is not related.

1 0
replied on July 20, 2019

I am also having this issue now and we are definitely using LFDS authentication vs repository authentication. This just started today. When I look at the Forms Server event viewer I see this message repeated about 50-100x:

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.&lt;&gt;c__DisplayClass7.&lt;GetResults&gt;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.&lt;System.Collections.Generic.IEnumerable&lt;T&gt;.GetEnumerator&gt;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.&lt;&gt;c__DisplayClass6_0.&lt;StartRouting_Async&gt;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&amp; connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; 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.&lt;&gt;c__DisplayClass1.&lt;Execute&gt;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>

 

Could the connection to the SQL db be the problem?

 

 

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...