Skip to main content

Prerequisites

Verify Database

To verify, open Microsoft SQL Server Management Studio and connect to the SQL Server instance where the Event Journal database is configured.

Once connected,

image32.png

  1. Expand the EJournal database.

  2. Expand Tables.

  3. Select the JOURNAL table.

  4. Right click the JOURNAL table and choose SELECT TOP 1000 Rows. This should display data from the table.

If the database or table does not exist, or no data is displayed, contact Emerson Automation Solutions technical support to troubleshoot and correct these issues.

SQL Server Considerations

When using SQL Server there are some things to take into consideration including remote connectivity and user authentication. For information on what to consider, see the technical note: How to Configure Microsoft SQL Server.

Server Name and Port

Emerson Automation Solutions recommends that the SQL Server Browser Service not be running for the SQL Server instance containing the EJournal database. Therefore, when connecting remotely, the SQL Server Instance name must be manually entered. It will not appear in any list.

In DeltaV version 14.3 and above, the Port Number for the SQL Server instance containing the EJournal database is 55114, which is not the default port of SQL Server.

In this section: