Attach template files for SQL Server

Attach the appropriate database template file for your SQL Server version (2005/2008/2012).

1. Run SQL Server Management Studio (Express) (SSMS). Note that you may need to install SQL Server Management Studio Express (SSMSE) separately.

2. Right-click Databases and select Attach.

3. In the Attach Databases window, click Add under the Databases to attach field.

4. Browse to the database template file. Do not attach to the files in the default location, PIPC\PimlWindows\Data. Be sure that the template files have been copied to a different location with write privileges.

5. Select the appropriate PIMLWindows .MDF file for your version of SQL Server and click OK. Verify the Current File Path for both the Data and Log File Types in the Database Details section of the Attach Databases window.

6. In the Attach Databases window, click OK to attach the database.

   The database is displayed in the SQL Server Management Studio (Express) tree.

7. Add the PI Manual Logger users. Make sure that the default schema for these users is set to dbo. Note that the Default Schema field cannot be populated for a Windows group and that dbo is assumed.

   Note: The database template needs to be attached to only one SQL Server and made accessible for all PI Manual Logger clients that connect to this particular database. However, different sites may want their own SQL Server Database because they do not share or need access to the tours of another site.

   Note: There should be a one-to-one correspondence for one PI Manual Logger database to the desired PI Data Archive. Refer to PI Manual Logger architecture for examples of different architectural designs that can be used.