Editing the LaserFiche for Microsoft SQL Server Service Registry Key's DependOnService Registry String.

April 19, 2004 | KB: 1000446
Server (MSDE) 6, Server (MSSQL) 6

Summary

The DependOnService string prevents a service from starting until another necessary service is first started. This article presents information on either creating and editing this string, or removing this string.

If the LaserFiche Server is installed on the same computer as the Microsoft SQL Server or MSDE, the DependOnService registry string must be set to the correct dependency service in order to allow LaserFiche to start properly. In this case, the LaserFiche for Microsoft SQL Server service may be starting before the MSDE (MSSQL$LASERFICHE) or Microsoft SQL Server (MSSQLSERVER) service. Edit the DependOnService registry string to prevent the LaserFiche for Microsoft SQL Server service from starting up before the MSSQL$LASERFICHE or MSSQLSERVER services. See Resolution 1.

If you ever decide to move your SQL Server to another computer or upgrade MSDE to Microsoft SQL Server and decide to place the SQL Server on a separate computer, the DependOnService key should be removed. If the string is not removed, it can prevent the LaserFiche for Microsoft SQL Server service from starting. Since the MSSQLSERVER service does not exist on the same computer, the LaserFiche for Microsoft SQL Server service would be depending on a service that would never start. Remove the registry string to prevent this error. See Resolution 2.

Resolution 1

The dependency setting for the LaserFiche for Microsoft SQL Server service may not be correctly set. Edit the corresponding registry key to add the dependency string.

Notice: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, visit the Microsoft Knowledge Base and search for Article ID: 256986.

To edit the LaserFiche for Microsoft SQL Server DependOnService registry string:

  1. Click Start and click Run.
  2. Type "regedt32" and click OK to enter the Windows Registry editing tool.
  3. Locate the LaserFiche for Microsoft SQL Server key.
    1. Expand My Computer.
    2. Expand HKEY_LOCAL_MACHINE.
    3. Expand SYSTEM.
    4. Expand CurrentControlSet.
    5. Expand Services.
    6. Select LaserFiche for Microsoft SQL Server
  4. On the right-hand side of the registry, make sure there is a string called "DependOnService."
  5. If the string does not exist, add the string by doing the following:
    1. From the Edit menu, select New and Multi-String Value.
    2. Name the string DependOnService
  6. To set the string value, click the string and from the Edit menu, select Modify.
  7. Perform one of the following:
    • Set the string to MSSQL$LASERFICHE if the installation is running on MSDE.
    • Set the string to MSSQLSERVER if the installation is running on the full version of Microsoft SQL Server.
  8. Restart the computer to restart the LaserFiche for Microsoft SQL Server service with the new dependency setting.

Resolution 2

Delete the DependOnService registry string to remove the LaserFiche for Microsoft SQL Server service's dependency on the MSSQLSERVER service.

To remove the LaserFiche for Microsoft SQL Server DependOnService registry string:

  1. Follow steps 1-4 from the previous resolution.
  2. Click the DependOnService string.
  3. From the Edit menu, select Delete.
  4. Click Yes when prompted for confirmation.
  5. Restart the computer to restart the LaserFiche for Microsoft SQL Server service.