Summary

After using the Laserfiche Administration Console to unregister a migrated standalone repository, re-registering the same repository can result in the attachment of the incorrect SQL Database files.

Cause

During the migration process of a standalone repository, the Laserfiche 6 to 7 Migration wizard creates new MSDE database files in the repository folder. The original MSDE database files are not renamed nor are they removed. This can cause issues if you unregister the migrated standalone repository.

MSDE database files are automatically detached from SQL Server when a standalone repository is successfully unregistered. Registering the same standalone repository may not attach the correct MSDE database files to SQL Server. This occurs because there are multiple sets of MSDE database files in the repository folder and the Laserfiche Administration Console does not know which set of database files to attach.

Workaround

Manually register the repository and attach the correct MSDE database files.

To attach a MSDE database

1. Click here to download AttachDb.vbs.
2. Double-click AttachDb.vbs to run the script.
   1. In the first dialog box, type ComputerName\Laserfiche. The term ComputerName represents the name of the computer where the SQL server resides. Click OK.
   2. In the second dialog box, type in the name of the SQL database that you would like to attach.
   3. Type in the full path and filename for the specified database. Click OK.
3. Rerun the script for any expansion databases.

To create the repository configuration registry keys

1. Click here to download "LocalRepositoryRegistryKey.vbs."
2. Double-click "LocalRepositoryRegistryKey.vbs" to run the script.
   1. In the first dialog box, type the name of your standalone repository and click OK.
   2. Type the name of your SQL Server and click OK.
   3. Type the name of your SQL database and click OK.
   4. Type the path to your local repository and click OK.