Configure the certificate for encrypted connection to the database

SQL Server can use Transport Layer Security (TLS) to encrypt data that is transmitted across a network between an instance of SQL Server and an application. TLS can be used for server validation when a client connection requests encryption.

For encrypted connection to the database, besides configuring a certificate on the SQL Server computer, you also need to:

Configure the certificate for the HMI server, if SQL Server is used for FactoryTalk View SE data grids.

Configure the certificate for the alarms and events server, if SQL Server is used for alarms and events.

We recommend using certificates from a public certification authority. Encryption with a self-signed certificate is possible, but a self-signed certificate offers only limited protection.

Prerequisites

The certificate must meet the certificate requirements for SQL Server to load a certificate.

To configure the certificate for encrypted connection to the database

Install the certificate on the SQL Server computer.

Install the certificate on the alarms and events server or HMI server.

Create a data grid object

Install the certificate on the SQL Server computer

Install the certificate on the associated computers

Create a database connection

Provide Feedback

Have questions or feedback about this documentation? Please submit your feedback here.