Summary

A SQL Server login account is required when creating or attaching a Laserfiche repository. This login will become the owner of the user tables for the SQL database associated with the Laserfiche repository. As the owner, this login must be a member of the db_owner and public database roles on that SQL database.

More Information

The following instructions verify that the SQL Server login assigned to the user tables is a member of the public and db_owner roles.

To verify login permissions (SQL Server Enterprise Manager)

1. Click Start, point to All Programs, Microsoft SQL Server, and click Enterprise Manager.
2. Expand the Microsoft SQL Servers node.
3. Expand the SQL Server Group node.
4. Expand the SQL Server hosting the SQL database associated with your Laserfiche repository.
5. Expand the Security node.
6. Click the Logins item.
7. Select the login that is the owner of the user tables for the SQL database associated with your Laserfiche repository. If you are not sure which login is the owner of the appropriate user tables, then you will need to expand the Databases node, expand the node for the desired database, and then select Tables. The owner of each table will be displayed. If the owner of your user tables is dbo, then you do not need to check permissions.
8. From the Action menu, click Properties.
9. In the SQL Server Login Properties dialog box, click the Database Access tab.
10. Select the database associated with your Laserfiche repository.
11. Under the Permit in Database Role table, make sure that the login is a member of the public and db_owner roles.