Create a database connection

Create a database connection for data grid to retrieve data from a SQL Server database.
To create a database connection
  1. In the
    FactoryTalk Administration Console
     or
    FactoryTalk View Studio
     Explorer window,
    expand the folders
    System
     >
    Connections
     and then right-click the
    Databases
     folder. Click
    Add Database Connection
    .
  2. On the
    Database Connection
    tab, in the
    Database type
     list, select
    FactoryTalk View SE Data Grid Database
    .
  3. In the
    Definition name
     text box, specify the name for the collection of data.
  4. In the
    Server name\instance
     text box, specify the host name of the computer where the specified database resides, or the SQL Server instance name on the computer in the following format:
    ComputerName\InstanceName
    .
    You can also click the
    Browse
     button to search for the computer that supports the specified database type.
  5. Configure the sign-in and encryption settings.
    • In the
      Authentication
       list:
      • Select
        Windows Authentication
         to use the currently logged-on user to log on to the database. To implement Windows-based authentication for SQL Server, click
        Configure Windows Authentication
        .
      • Select
        SQL Server Authentication
         to specify an existing database user name (must be a SQL Server authenticated user with administrative rights)
        ,
        and then type the password for the database user name specified
        .
    • Configure the encryption.
      • If
        Encrypt connection
         is selected:
        • When
          Trust server certificate
           is cleared, the HMI server or alarms and events server starts the certificate handshake process to validate the certificate on the SQL Server computer. If the certificate is not present or if the validation of the certificate fails, the connection is closed.
          Important
          : In cases where the
          Trust server certificate
           setting is cleared, if SQL Server is used for FactoryTalk View SE data grids, you must configure the certificate for the HMI server. If SQL Server is used for alarms and events, you must configure the certificate for the alarms and events server.
           For more information, see Configure the certificate for encrypted connection to the database.
        • When
          Trust server certificate
           is selected, the HMI server or alarms and events server does not validate the certificate on the SQL Server computer.
      • If
        Encrypt connection
         is cleared, the
        Trust server certificate
         setting is ignored.
  6. In the
    Database name
     text box, specify the name of the database that you want to retrieve data from.
    You can also click the
    Browse
     button to search for the available databases located on the specified computer.
    TIP:
    Only existing databases can be specified for the Data Grid connection.
  7. Click
    OK
    .
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal