Citadel Error SQL Event ID 5123

[skibum019]

On system where Lookout 6.1 is installed, I am receiving multiple application errors in the event log stating Event ID 5123.

CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'c:\program files\national instruments\lookout 5.1\database\cmp\mssql.mdf'.

How do I get it to discontinue trying to create these files?  There is no database at the location mentioned above.

[LabBEAN]

Did you ever figure out why you were getting that error in your event log?  Seeing something similar at a customer site...

Also seen this one:

---

 

Event ID:  0
Source:  NI Citadel

The description for Event ID ( 0 ) in Source ( NI Citadel ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details.

The following information is part of the event:
Citadel failed to create alarms and events database in this folder:
c:\program files\applet\vibration\data

Ensure you have proper access to this folder, refer to LabVIEW help topic "Logging Historical Data (DSC Module)" for more information about this issue.

---

[Ryan.S]

If your customer is LabVIEW DSC user, refer to the topic "Logging Histortical Data with the Citadel Database(DSC Module)" in LabVIEW help.

Here I post the help content for the Lookout user. Basically the problem is the Citadel user doesn't have write permission to the database folder. If the OS is VISTA, the requirement is a little bit complicated.

Specifying an Appropriate Database Location

To ensure that datalogging to the Citadel database is successful, you must specify an appropriate database location to which the DSC Module has full access.

(Windows XP) By default, the DSC Module stores the Citadel database in the labview\data folder. If you want to store the database in a different folder, ensure that the folder is writable by the NETWORK SERVICE user.

(Windows Vista) By default, the DSC Module configures appropriate access rights for the labview\data folder and stores the database in that folder. If you want to store the database in a different folder, ensure that the folder meets the following requirements:

• The database folder is readable by all members of the USERS group. The Citadel database is a shared resource and must be available to all users of the system. Alarm logging fails if the database folder is not readable to all users.
• The database folder is writable by the user who wants to log data.
• The database folder is readable and writable by the SYSTEM user. The Citadel service runs as a SYSTEM user and must have sufficient access rights to manage the database files.
• The database folder is writable by the NETWORK SERVICE user. By default, the folders under the C:\Users directory and the top-level folders that the NETWORK SERVICE user creates are writable by that user.

If you do not store the database in the labview\data folder, National Instruments recommends that you place the database under the Windows Public user directory, located at C:\Users\Public. This folder always meets the requirements above. Do not use the following folders to store the database:

• C:\Windows—The system has highly restricted access to this folder.
• C:\Users\Username—This folder is visible only to the owning user, so the system has restricted access to this folder.

[LabBEAN]

In this case, I was able to right click the project library » Properties » DSC Settings:  Database » uncheck Enable Data Logging and uncheck Enable Alarms and Events Logging.