Navigation:  SoftExpert Suite installation with Docker > Additional procedures >

TLS configuration with SQL Server

First, to configure TLS, the client database must have protocol TLS 1.2 enabled.

Moreover, it is necessary to have an internal DNS server to map DNS in the database.

Access the database server and configure the certificate in the client environment. To do that, follow the steps below:

1.On the search bar, enter "Microsoft Management Console (MMC)" and run it as admin.

2.In the File option, choose Add/Remove Snap-in.

3.Select Certificates and add.

4.A window will be opened requesting the account; select Computer Account and click on Finish.

5.Click on OK on the Add/Remove dialog box.

6.Click to select the Personal folder.

7.Right-click, select All tasks, and click on Request New Certificate again.

8.Click on Next in the Certificate Request Wizard and select the "Computer" certificate type.

With these requirements, follow the steps to configure TLS with SQL Server:

1.Make sure SoftExpert Suite is stopped:

Or, if the installation is using another disk, such as D:

2.Remove the current database configuration:

Or, if the installation is using another disk, such as D:

Use the 3 - Remove database option.

3.Run the script again and select the option to add databases.

Or, if the installation is using another disk, such as D:

4.Choose SQL Server and the option with TLS 1.2; enter the database configuration. Remember to use the database DNS.

5.Then, equalize the database:

Or, if the installation is using another disk, such as D: