Summary

Laserfiche is reduced to limited functionality if the Microsoft SQL database files have been marked as read-only. The SQL database files can be inadvertently marked as read-only if the SQL database files were transferred from one computer to another computer through the use of a CD.

The Laserfiche client will open in Viewer mode when accessing such a repository. Performing tasks on such a repository through the Laserfiche Administration Console will result in the following error message:

Permission denied [7332]

One method of checking to see if you are encountering this issue is to view the "Sessions" item of the affected repository in the Laserfiche Administration Console. In the License column, check to see if a "Retrieval User" license is in use for users that should have write access to the repository.

Resolution

Perform the following steps:

1. Remove the read-only flag from the Microsoft SQL database files
2. Detach and reattach the database files
3. Unregister and reregister the Laserfiche repository

To remove the read-only flags from the Microsoft SQL database files

1. Using Windows Explorer, browse to and select the affected .mdf and .ldf files. The default locations for these files depends on whether you are using the full version of Microsoft SQL Server or MSDE:
   • Full version of Microsoft SQL Server: C:\Program Files\Microsoft SQL Server\MSSQL\Data
   • MSDE: The Laserfiche repository folder
2. From the File menu, click Properties.
3. Clear the Read-only option.

To detach and reattach the SQL database files

Detailed information can be found in the following Knowledge Base article:

1011003 Attaching and Detaching a Microsoft SQL Server Database.

To unregister the Laserfiche repository

1. Start the Laserfiche Administration Console.
2. Expand the Laserfiche Server that will broadcast the desired repository.
3. Expand the tree item labeled "Repositories."
4. Select the desired repository.
5. Optional. If security has been enabled on the selected repository, log in to the repository.
6. From the Action menu, point to All Tasks, and then choose Unregister Repository. When prompted, confirm that the Laserfiche Server will no longer broadcast the selected repository.
7. The Laserfiche Server Login dialog box will appear. Specify the system manager password.
8. Click OK to unregister the repository.

To register the Laserfiche repository

1. Start the Laserfiche Administration Console.
2. Expand the Laserfiche Server that will broadcast the desired repository.
3. Select the tree item labeled "Repositories."
4. From the Action menu, point to All Tasks, and then choose Register Repository. The Laserfiche Repository Registration wizard will appear.
5. Proceed through the wizard to register your Laserfiche repository.