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

Question

Question

New installation of Forms and MS SQL

asked on February 2, 2020 Show version history

I am trying to install and configure LF Forms on the same server that the database resides (SQL Server 2017), I kept Default Account for both fields, but I am stuck on the first configuration page where it asks me to connect to a database server.

It seems the local account does not have sufficient access to database which is odd as Laserfiche, LF Audit trail, and LF Workflow are fine.

 

In SQL log the error says: Login failed for user '...….\…...$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

So as of now:
 

1- Laserfiche forms routing services is running using Local System account

2-  Forms App Pool is using ApplicationPoolIdentity

 

Should I create a new SQL user dedicated for LF Forms (and what is the needed authority) or I should give authority to the local system account (and what is the needed authority) ?

 

0 0

Answer

SELECTED ANSWER
replied on February 2, 2020

Hi Ali,

First, you are seeing this issue because SQL Server does not support the use of built-in system accounts (like Local System and Network Service) for Windows Authentication. You can do one of the following two things:

First option:

Create an AD user account to run the Forms Routing Service and IIS FormsAppPool. This will make Windows Authentication work. If you are unfamiliar with how to change service identities, the easiest way to make that change will be to uninstall Forms, reinstall Forms, and enter the AD account info during the installation when prompted by the install wizard.

Second option:

  1. Create a "SQL server authentication account" for use with Laserfiche. Give it the "dbcreator" role and set a strong, auto-generated password with a minimum of 24 characters. There are many good password generators online such as this one.
    See: Create a login with SQL Server Management Studio.
  2. Set the SQL Server authentication mode to "SQL Server and Windows Authentication mode". Restart the SQL Server service so the change takes effect.
    See: Change server authentication mode with SQL Server Management Studio.
  3. In FormsConfig, under Authentication select "Use SQL Server Authentication". It will then display Username and Password fields. Provide the credentials for the SQL account you created in Step 1. Specify your database and then click "Save".

 

With that said, if this is a Production system for more than a few users, we strongly recommend you do not install any Laserfiche applications on the same server as SQL Server. This goes for any applications, not only Laserfiche. SQL can be incredibly resource hungry and can cause performance issues for any other services on the same server. There are also security considerations. If you have the option, I would definitely put Forms on its own instance with other Laserfiche web apps. All of the instructions above are valid regardless of where you install Forms.

0 0
replied on February 2, 2020

I hope LF update their help files with your answer. Thank you.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.