Question

Connecting Forms 11 to Azure SQL

Forms

Updated April 28, 2021

asked on April 12, 2021

Good day ,

We host our SQL DB in Azure and can connect to it and run our production environment for Workflow, Directory Server and Forms 10.4.5 with no issues.

In our test environment we installed Forms 11 and connected to the same production Forms DB and received the following error -

Laserfiche Forms requires SQL Server 2014 SP3+, 2016 SP2+ or later. [LFF3602-UnsupportedSQLVersion]

The SQL is currently version 2019. Has anyone had issues or success in using Azure SQL with the latest Forms version?

Thanks

Ian

0 0

Replies

replied on April 13, 2021

Good day Ziyan Chen,

The result is 12.0.2000.8

The Compatibility Level is set SQL 2019 ( 150 )

1 0

View 2 previous replies

replied on April 14, 2021

Hi Ian,

Forms should work with Azure SQL, while we missed to take Azure SQL into consideration when implementing SQL version check in Forms 11.

I have filed a bug for this(316798) and will fix it in upcoming Forms release, targeting in mid of May. Is it okay for you to stay 10.4.5 until then?

0 0

replied on April 20, 2021

Good day Ziyan Chen,

Thank you, would this bug be just for Forms or all LF products as I'd also like to begin updating LF Server and WF

Regards

Ian

0 0

replied on April 21, 2021

Let me get back to you on this after checking with LF Server and WF team.

For the bug in Forms, we are planning to release an individual hotfix for this issue before next release comes out. Will update more information when it is available.

0 0

replied on April 22, 2021

Hi Ian, I've confirmed this is Forms only bug.

0 0

replied on April 28, 2021 • Show version history

Hi Ian,

The Forms 11 hotfix for this issue is now available at https://support.laserfiche.com/kb/1014297/list-of-changes-for-laserfiche-forms-11-hotfix-1014297

And the fix will also be included in next release.

0 0

replied on April 13, 2021

Hi Ian,

Could you run

SELECT SERVERPROPERTY('productversion')

on Azure SQL and post the result?

0 0

You are not allowed to follow up in this post.

Question

Question

Connecting Forms 11 to Azure SQL

Replies

Sign in to reply to this post.