The Laserfiche Social BPM 9.2 Preview Configuration Page Displays An "ERROR [42000] [Microsoft][SQL Native Client][SQL Server]Invalid filegroup 'LfAnswersStreamGroup1' specified" Message.

April 20, 2015 | KB: 1013637
Laserfiche Social BPM 9.2 Preview

Summary

The Laserfiche Social BPM 9.2 Preview Configuration page displays one of the following error messages:

    ERROR [42000] [Microsoft][SQL Native Client][SQL Server]Invalid filegroup 'LfAnswersStreamGroup1' specified.

    ERROR [42000] [Microsoft][SQL Native Client][SQL Server]FILESTREAM feature is disabled.

Resolution

Laserfiche Social BPM relies on the FILESTREAM storage feature in Microsoft SQL Server. Prior to configuring a SQL database for Laserfiche Social BPM, enable the ENABLE FILESTREAM for Transact-SQL access option for the appropriate SQL Server instance.

  1. On the machine where Microsoft SQL server is installed, open SQL Server Configuration Manager.
  2. In the left pane of the SQL Server Configuration Manager, select SQL Server Services.
  3. Select the SQL server on which Laserfiche Social BPM will use.
  4. Right-click the server instance and click Properties.
  5. In the SQL Server Properties dialog box, click the FILESTREAM tab.
  6. Select the Enable FILESTREAM for Transact-SQL access check box.
  7. Click OK.

Note: You may need to restart the SQL Server instance after enabling FILESTREAM.