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

Question

Question

Connect forms to azure db service

asked on January 13, 2020 Show version history

We are installing a test environment on ms azure for the customer they are using azure database service. LF Server and WF are working fine and they connect to the db with no problem at all. We are using only one db user. When we try to configure Forms we entered the db server and the db user then it lists the available dbs, we select the one we need and when we clic the Save button it shows the following message:

 

"User 'db_user' was unable to authenticate to Sql Server 'prodbdlaserfiche.database.windows.net'. [LFF13-UserUnabletoAuthenticateToSQL]".

 

'db_user' has db_executor and db_owner permissions.

 

Anybody that can help us with any ideas about what could be the problem¿?

Do LF Forms support that kind of azure db services¿?

Image2.jpg
Image2.jpg (75.39 KB)
0 0

Answer

SELECTED ANSWER
replied on January 15, 2020

I think you'll need to use Forms 10.4.2, which is compatible with Laserfiche 10.2.1 applications. You can find it as part of the Laserfiche 10.4.2 install package.

Release Notes for Laserfiche Forms 10.4.2

List of Changes for Laserfiche Forms 10.4.2

Added support for the following public cloud managed database services:

  • Microsoft Azure: Azure SQL Database, Azure SQL Database Managed Instance
  • Amazon Web Services (AWS): Amazon RDS for SQL Server

 

1 0

Replies

replied on January 15, 2020

Hi Robinson,

Laserfiche Forms supports Azure SQL Database as of version 10.4.2, released December 2019. What version of Forms are you using?

If you're using Forms 10.4.2 or higher, check the following:

  • Make sure your database server name is correct. I see you have "bd" instead of "db" in the name. Not sure if that's correct for base de datos or a typo.
  • In your post you say the account "db_user" has the correct permissions, but your screenshot shows the username "administrador". Which is the right one?
  • Look in the Forms Event Logs for the actual error message from the SQL driver rather than the one Forms shows in the UI. It may have additional useful information. This one is key to identifying the true issue. Please respond with any event log messages related to SQL that you find and we can assist from there.
1 0
replied on January 15, 2020

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)

0 0
SELECTED ANSWER
replied on January 15, 2020

I think you'll need to use Forms 10.4.2, which is compatible with Laserfiche 10.2.1 applications. You can find it as part of the Laserfiche 10.4.2 install package.

Release Notes for Laserfiche Forms 10.4.2

List of Changes for Laserfiche Forms 10.4.2

Added support for the following public cloud managed database services:

  • Microsoft Azure: Azure SQL Database, Azure SQL Database Managed Instance
  • Amazon Web Services (AWS): Amazon RDS for SQL Server

 

1 0
replied on January 15, 2020

I want to note that as of LF 10.4.2, all application databases besides Audit Trail support Azure SQL Database. Everything including Audit Trail works with Azure SQL Database Managed Instance.

1 0
replied on January 16, 2020

Hi Samuel, Im going to test using your indications and let you know. Thanks. 

0 0
replied on January 16, 2020

Samuel, thank you so much for your indications. After installed Forms version 10.4 the connection to the azure db service was successful.

1 0
replied on January 16, 2020

Wonderful! I'm glad to hear it's working for you now :)

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

Sign in to reply to this post.