Navigation:  Traditional SoftExpert Suite installation > Pre-required activities > Database configuration >

Microsoft SQL Server - TLS

 Previous  Top  Next

This section will show the procedure for configuring TLS certificate in Microsoft SQL Server. To do that, take the following steps:

 

1.To configure SQL Server with TLS, first, the database must have protocol TLS 1.2 enabled, and protocols 1.1 and 1.0 disabled.

 

The configuration of the protocols is the customer's responsibility!

 

2.Then, it is necessary to remove the old ODBC and native client drivers via Control panel.

3.Download and install the following drivers:

▪Native client 2012

▪ODBC Driver 18(x64)

4.Enable data encryption in the properties of SQL Server.

5.Restart the database service.

6.At this point, a CA certificate will be requested by the database. Add it, as required.

 

For more details on how to configure the certificate in the database, go to: https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/.

 

7.After configuring the database, run SoftExpert Configurator.

8.Remove the current connection and create a new one.

9.In the JDBC Driver, select the "SQL Server - With TLS" option and proceed with the parameterization of the connection with the database.