Summary

When you attempt to attach the database in the LaserFiche Administration Console, you may receive the following error message:

Error in attaching database to server

Cause

There are three common causes for this error and they are listed as follows:

1. The paths entered for the database and/or SQL data file locations are incorrect. See Resolution 1.
2. The database is already attached in Microsoft SQL Server. See Resolution 2.
3. The database key is present in the registry. See Resolution 3.

Resolution 1

Make sure that you type in the correct paths for the database location and the SQL file location. Retry attaching the database in the LaserFiche Administration Console.

Resolution 2

Detach the database from SQL Server first. Then retry attaching the database in the LaserFiche Administration Console.

1. Click here to download DetachDb.vbs.
2. Double-click DetachDB to run the script.
3. From the first LaserFiche dialog box, type ServerName\LaserFiche. The term ServerName represents the name of the computer where the SQL server resides. Click OK.

   Note: If you upgraded LaserFiche Team (Group) to LaserFiche United (Standard\Enterprise), then you should only specify the name of the computer where the SQL server resides.

4. From the second LaserFiche dialog box, type in the name of the SQL database that you would like to detach.
5. Start the LaserFiche Administration Console.
6. Select the computer you want to attach the database to.
7. From the Action menu, click Attach Database.
8. Type in the appropriate database name, the path containing the database, and the path to the SQL data files.
9. Click OK.

Resolution 3

LaserFiche does not allow you to attach databases with duplicate names. If you are confident that the desired name is not really in use, then you should check whether an old registry key has not been removed.

Use the Windows registry editor tool to remove a database key:

1. From the computer hosting the LaserFiche Server, click Start, and then select Run.
2. In the Open text box, type "regedt32" and click OK.
3. In the Windows Registry Editor tool, locate the following key: HKEY_LOCAL_MACHINE\SOFTWARE\LaserFiche\Database\SQL.
4. Under this key look for a key that matches the database you are trying to attach.
5. Click the matching key, and from the Edit menu, click Delete.
6. Restart the computer and retry attaching the database.