SQL Server configuration
- Last UpdatedNov 22, 2022
- 1 minute read
- PI System
- PI Manual Logger 2017 R2
- Visualization
PI Manual Logger stores all configuration metadata and temporarily stores manually entered data in a SQL Server database. If you select Database Files during installation, all template database files are installed. These include template files for SQL Server 2012/2014/2016 Express, SQL Server 2008 Express, and SQL Server 2005 Express. There are two files, one with an .LDF extension and one with an .MDF extension.
SQL Server template files
The template files for the version of SQL Server that you are using are located in the PIPC\PIMLWindows\Data folder.
|
Database |
SQL Server |
MDF filename |
LDF filename |
|---|---|---|---|
|
PimlWindows |
2005 |
PIMLWindows.mdf |
PimlWindows_log.ldf |
|
PimlWindows |
2008 |
PIMLWindows2008.mdf |
PIMLWindows2008_log.ldf |
|
PimlWindows |
2012 and greater |
PIMLWindows2012.mdf |
PIMLWindows2012_log.ldf |
|
PIMLWindowsMobilePC |
Any (Express edition recommended) |
PIMLWindowsMobilePC.mdf |
PimlWindowsMobilePC_log.ldf |
Before you attach the appropriate database template for your SQL Server version, you must:
-
Copy the Manual Logger template database files to a secure location, for example on the SQL Server. For MobilePC configuration, the template database files must be copied to a location on the local computer.
-
Make sure the template database files are not write-protected.
-
Make sure the SQL Server account has Windows read/write permission to these database files; otherwise an error message may appear.
-
For example, you can copy the database files to \Program Files\Microsoft SQL Server\MSSQL.1\Data on the SQL Server so that the SQL Server has full permission to read and write files under this folder.