Logging Audit Trails to an SQL Database SECTION 13 CFR (Title 21 Part 11) Function-
211
13-5-1 SQL Server Database Prerequisites
The following conditions need to apply before logging to an SQL Server
database can proceed:
1. Ensure you have access to an SQL Server.
2. The necessary security permissions are applied to update the database to
be used for audit logging.
3. A database is created to be used for the Audit Trail.
NOTE: Once the SQL Server database exists. CX-Supervisor will create the
required tables in the specified database (if they do not already exist) namely,
Points, Alarms, Events and Errors. The same tables as are created for the
Microsoft Access database.
4. The database name has been correctly specified in the Audit Trail
Configuration settings.
5. The connection string has been specified correctly.
13-5-2 Creating an SQL Server Test Project
To create a test application, convert the test project described in the sections
above,
Or
Create a test project as described in the sections ‘Creating and Running a
CFR Application (using Microsoft Access).
Then select the SQL Server option in the Audit trail Configuration settings
dialog.
To Next Page
Loading...
Need help?
General