Summary

The ability to create or modify a LaserFiche database may depend upon the manner in which security has been configured on the SQL Server. When configuring the LaserFiche Server service, you may use a local system account or a domain account when authenticating to the SQL Server. Regardless of the type of account used to authenticate to the SQL Server, you should keep in mind that if the specified account does not have sufficient rights to the SQL Server then you will encounter access issues. The two basic types of authentication are discussed below.

• Mixed mode: Mixed mode takes advantage of both SQL Server and Windows authentication. When the SQL Server security has been set to mixed mode, then you should make sure that the specified user account complies with one of the following requirements:
  • The user account should belong to the Window's administrators group on the computer hosting the SQL Server.
  Or:
  • A SQL Server user should be created with the same name as the specified user account. The System Administrator right should be granted to the new user.
• Windows authentication: This type of mode requires that the specified user account already belong to the domain. This user must belong to the Window's administrators group on the computer hosting the SQL Server.

Note: Before modifying security settings, we recommend that you refer to the SQL Server documentation.