TLS configuration with SQL SERVER

First, to configure the TLS certificate, the customer's database must have the TLS 1.2 protocol activated.

Moreover, there must be an internal DNS server to map the DNS in the database.

Access the database server and configure the certificate in the customer's environment.

1. In the search bar, type Microsoft Management Console (MMC) and run it as Administrator.

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

3. Select Certificates and add.

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

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

6. Click to select the Personal folder.

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

8. Click on Next in the Certificate Request Wizard, then select the 'Computer' certificate type.

With these requirements met, follow the steps to configure the TLS certificate with SQL SERVER.

10. Make sure SoftExpert Suite is stopped.

C:\sesuite\sesuite.ps1 stop

11. Remove the current database configuration.

C:\sesuite\sesuite.ps1 database

12. Use option 3 - Remove database.

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

C:\sesuite\sesuite.ps1 database

14. Choose SQL Server, then the option with TLS 1.2; enter the database configuration. Remember to use the database DNS.

15. Then, equalize the database.

C:\sesuite\sesuite.ps1 equalize