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

Question

Question

Laserfiche Forms V10, Laserfiche Forms has encountered a Problem

Forms Version 10 Installation and Upgrades
Updated April 20, 2016
asked on January 11, 2016

I've upgraded my Laserfiche system from V9.2 to Version 10 including forms. Everything appears to be functioning correctly except Forms. When I launch Forms (localhost/Forms) in either Chrome or Firefox, I get the error "Laserfiche Forms has encountered a Problem, the underlying provider failed to open"

The event viewer is showing the following "Login failed for user 'IIS APPPOOL\FormsAppPool'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]" more details below.

Thoughts to fix this?

 

 

 

Log Name:      Application
Source:        MSSQL$SQLEXPRESS
Date:          1/11/2016 12:46:35 PM
Event ID:      18456
Task Category: Logon
Level:         Information
Keywords:      Classic,Audit Failure
User:          IIS APPPOOL\FormsAppPool
Computer:      LaserVM
Description:
Login failed for user 'IIS APPPOOL\FormsAppPool'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQL$SQLEXPRESS" />
    <EventID Qualifiers="49152">18456</EventID>
    <Level>0</Level>
    <Task>4</Task>
    <Keywords>0x90000000000000</Keywords>
    <TimeCreated SystemTime="2016-01-11T20:46:35.000000000Z" />
    <EventRecordID>40479</EventRecordID>
    <Channel>Application</Channel>
    <Computer>LaserVM</Computer>
    <Security UserID="S-1-5-82-3087095105-1238034067-4084607481-1707703565-4111600081" />
  </System>
  <EventData>
    <Data>IIS APPPOOL\FormsAppPool</Data>
    <Data> Reason: Failed to open the explicitly specified database.</Data>
    <Data> [CLIENT: &lt;local machine&gt;]</Data>
    <Binary>184800000E000000130000004C00410053004500520056004D005C00530051004C0045005800500052004500530053000000070000006D00610073007400650072000000</Binary>
  </EventData>
</Event>

0 0

Replies

replied on January 11, 2016

Hi Steve

The solution to your issue is to change the identity that FormsAppPool is running as in IIS

 Open IIS and in the Application Pool on the left, right click on "FormsAppPool" in the centre and select "advanced setting" then under "Process Model" you will see "identity" change the identity from "ApplicationPoolIdentity" to the domain admin that you use to run Laserfiche Services.

Restart Forms in Services and it should be OK 

3 0
replied on January 11, 2016

Hello,

Ian beat me to the answering. Just wanted to add that if for some outside concern the identity here cannot be changed, or at least not to the domain admin, then you can manually create a login to SQL for the user specified in the log details and give it the same access as the domain admin.

If this does not resolve the issue, or if other problems arise, then you may want to consider opening a Support Case for further troubleshooting.

Cheers

0 0
replied on April 20, 2016

To open IIS Manager from the Start menu

  1. Click Start, and then click Control Panel.

  2. Do one of the following:

    • If you are using Windows Vista® or Windows Server® 2008, click System and Maintenance, and then click Administrative Tools.
       
    • If you are using Windows® 7 or Windows Server® 2008 R2, click System and Security, and then click Administrative Tools.
       

     

  3. In the Administrative Tools window, double-click Internet Information Services (IIS) Manager.

To open IIS Manager from the Search box

  1. Click Start.

  2. In the Start Search box, type inetmgr and press ENTER.

0 0
replied on January 12, 2016

I made the change suggested in Ian Day's response and now the error has changed to"Laserfiche Forms has encountered a problem, - The Forms database is from a previous version and must be updated.

This does appear to be covered by the Forms V10 installer. Can you provide a document to perform what is required?

0 0
replied on January 12, 2016

Please go into the FormsConfig site to update the database.

2 0
replied on January 12, 2016

That was the missing piece, Thanks

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

Sign in to reply to this post.

Details
Related Posts
Loading ...