Hi Samuel, thanks for your answer.
Answering your questions...
- Version 10.2.1. Rio Installer.
- Database name is correct.
- We tested with two users so I just typed 'db_user' as an example.
This is the error in the event viewer for the forms operational log:
[13]: User 'user_laserfiche_new' was unable to authenticate to Sql Server 'prodbdlaserfiche.database.windows.net'. [LFF13-UserUnabletoAuthenticateToSQL]
Details:
URL: /FormsConfig/Configuration/GetDbStatus
Error: UserUnabletoAuthenticateToSQL
Date: 1/15/2020 12:02:13 PM (SA Pacific Standard Time)
HTTP Status Code: 403
Business Process ID: 0
User: AMVCOLOMBIA\tandem
IP: ::1
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.117 Safari/537.36
Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: User 'user_laserfiche_new' was unable to authenticate to Sql Server 'prodbdlaserfiche.database.windows.net'. [LFF13-UserUnabletoAuthenticateToSQL]
at FormsConfig.Infrastructure.DatabaseInfo.GetDbStatus()
at FormsConfig.Controllers.ConfigurationController.GetDbStatus(DatabaseInfo databaseInfo)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)