Manually Registering a Laserfiche Repository.

January 21, 2005 | KB: 1000863
Server (MSDE) 7, Server (MSSQL) 7, Server (Oracle) 7

Summary

Registering a repository involves the creation of a registry key and several registry values. If you do not wish to use the Laserfiche Administration Console to perform this task, you can manually create the necessary registry key and values.

More Information

You can use the Windows Registry Editor tool to manually register a repository. Each registered repository has a unique registry key stored under the following key: HKEY_LOCAL_MACHINE\SOFTWARE\LASERFICHE\Engine\7.x\Databases. Each repository key contains several values that specify basic information about your repository. See the following table for a listing of possible registry values.

Warning: Incorrectly editing the registry may adversely affect your system. Before you edit the registry, make sure you understand how to restore it if a problem occurs.

Name Type Description
Data Source REG_SZ Specifies the name of your Microsoft SQL Server or Oracle instance.
DBMS REG_SZ Specifies the type of DBMS. This option can be set to one of three possible values: Oracle, MSSQL, MSDE. Please note that for the purposes of this registry value, Microsoft SQL Server Personal Edition counts as MSDE.
Initial Catalog REG_SZ Specifies the name of your Microsoft SQL Server database. This value is not necessary if your repository uses Oracle.
Logging Level REG_DWORD Defines what type of errors are logged in the repository's error.log file. This option can be set to one of three possible values: 0, 1, 2. 0 means that only the most critical errors are logged. 1 logs both critical errors and non-critical errors. 2 is the default value used by the Laserfiche Administration Console and means that everything is logged.
Path REG_SZ Specifies the fully qualified path to the Laserfiche repository location. The Laserfiche repository location is the that folder contains the SEARCH folder. A sample repository path would be: "C:\LF7Repositories\MyRepository." Please note that this value cannot be a UNC path.
User ID REG_SZ Specifies the user name for your Oracle schema or Microsoft SQL Server. This value is not necessary if your Microsoft SQL Server is not set up to use SQL Server authentication.
Password REG_SZ Specifies the password for your Oracle schema or Microsoft SQL Server. This value is not necessary if your Microsoft SQL Server is not set up to use SQL Server authentication.

Warning: Be aware that your Oracle or SQL Server password registry value is not encrypted. Please take precautions to ensure that only authorized users are able to access the Laserfiche repository registry key.

To manually register a repository

  1. Click Start and then click Run.
  2. In the Run dialog box, type the following and click OK to load the Windows Registry Editor.

    regedt32

  3. Expand HKEY_LOCAL_MACHINE.
  4. Expand SOFTWARE.
  5. Expand LASERFICHE.
  6. Expand Engine.
  7. Expand 7.x.
  8. Click Databases.
  9. From the Edit menu, point to New and click Key.
  10. Assign the name of the desired repository to the key.
  11. From the Edit menu, point to New and click String Value.
  12. Name the value: Data Source.
  13. Double-click Data Source.
  14. Under Value data, specify the name of your Microsoft SQL Server instance or Oracle instance and click OK.
  15. From the Edit menu, point to New and click String Value.
  16. Name the value: DBMS.
  17. Double-click DBMS.
  18. Under Value data, type MSSQL, MSDE, or Oracle and click OK.
  19. Perform the following if your repository uses Microsoft SQL Server:
    1. From the Edit menu, point to New and click String Value.
    2. Name the value: Initial Catalog.
    3. Double-click Initial Catalog.
    4. Under Value data, enter the name of the Microsoft SQL Server database and click OK.
  20. From the Edit menu, point to New and click DWORD Value.
  21. Name the value: Logging Level.
  22. Double-click Logging Level.
  23. Under Value data, type 0, 1, or 2.
  24. Make sure that the Hexadecimal option is selected under Base and click OK.
  25. From the Edit menu, point to New and click String Value.
  26. Name the value: Path.
  27. Double-click Path.
  28. Under Value data, specify the path to your repository and click OK.
  29. Perform the following if your repository uses Oracle or if Microsoft SQL Server is set up to use SQL Server authentication:
    1. From the Edit menu, point to New and click String Value.
    2. Name the value: User ID
    3. Double-click User ID.
    4. Under Value data, specify the name of your Oracle login or SQL Server login and click OK.
    5. From the Edit menu, point to New and click String Value.
    6. Name the value: Password.
    7. Double-click Password.
    8. Under Value data, specify the password of your Oracle login or SQL Server login and click OK.

Note: If you are using Microsoft SQL Server, you should make sure that the SQL database specified in step 19 is attached to SQL Server.