Laserfiche Connector - Failed to connect to database
Friday, May 21, 2021 at 02:29pmAfter installing, "Send with OneSpan" is visible via Webclient on the "Custom Actions" & elispis tab.
When clicked, "Something went wrong" displays after 15 seconds.
The Event Viewer (Application) shows the error "Failed to connect to database"
The Event Viewer (Laserfiche/WebClient/Server/Operational) shows the error
"Object reference not set to an instance of an object."
I confirmed the WebAccessConfig.xml was updated with the OneSpan settings:
<OneSpanSignSettings>
<OSSCredential UserId="xxxx" Password="zzzzz" ApiKey="" Environment="US_1_Sandbox" />
<LFCredential UserId="testOneSpanAccount" Password="xxxxx" ServerName="TEST" RepositoryName="TEST" />
<MSSQLServerCredential UserId="xxxxx Password="xxxxx" DataSourceName="OneSpanSQLClient" DatabaseName="OSSInfo" />
<LFWorkflowConfiguration ServerName="localhost" Port="8085" />
</OneSpanSignSettings>
Environment: Laserfiche 10.4.1 on Windows Server 2019.
Windows 64-bit ODBC driver using the ODBC Driver 13 for SQL Server - Test Connection successful
Any help appreciated!
Reply to: Laserfiche Connector - Failed to connect to database
Tuesday, May 25, 2021 at 09:12amHi Chuck,
The integration uses a database to store transaction information. The database "OSSInfo" gets created during the installation process.
Can you please make sure that, the database got created ? Please also make sure that the machine with Laserfiche WebAccess can access the machine with the MSSQL server. You can use telnet to confirm the connectivity between the servers. Example - telnet your_sqlserver_datasource_name port_number
Thanks,
Moshiur Reza
Reply to: Hi Chuck, The integration…
Tuesday, May 25, 2021 at 12:59pmThanks for your suggestions. All that was good but after trying different options on the ODBC driver, I was able to get it to work.
- Use the MS ODBC 64-bit Data Source - use System DSN tab - click Add
- Selected "SQL Server" for the driver
- Important: Name it the same as the SQL server.
(I originally named it "OneSpanSQLClient" but this was the failure. When I named the name of the ODBC Source the same name as the SQL server, it worked.)
- Selected "Use SQL authentication using a login ID and password entered by the user."
Once I made that change, it worked great!
Hope this helps someone out there!
Reply to: Laserfiche Connector - Failed to connect to database
Tuesday, May 25, 2021 at 01:14pmGlad to help.
Reply to: Laserfiche Connector - Failed to connect to database
Saturday, April 29, 2023 at 03:10amOne critical safety measure is to use a ground fault circuit interrupter (GFCI) outlet or adapter. GFCIs detect electrical leaks and shut off the power to the outlet, preventing electrocution. If you're using your corded tool in wet conditions, a GFCI can be a lifesaver. why not find out more