Navigation:  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:

 

▪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!

 

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

2.Restart the database service.

3.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/.

 

4.After doing that, edit the database_config, changing the driver tag and adding the following tags:

vi /usr/local/se/conf/database_config.xml

<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>

<privilegedConnection>

<connectionName>$connection_name</connectionName>

<databaseUser>$user</databaseUser>

<databasePassword>$password</databasePassword>

</privilegedConnection>

 

5.Save and close the file:

wq!

 

6.Access the SE Configurator directory:

$ cd /usr/local/se/tools/configurator

 

7.Execute the following command to equalize the base:

# bash run.sh

 

All done. The configuration is complete!